View lawprod.MSCM.RECEIPT_LOG_VW Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
DISTRIB_LINE_ID number 5  √  null
RECEIVING_LOC_ID number 22
RECEIVING_LOC_EXT_ID varchar2 5
RECEIVING_LOC_DESC varchar2 50  √  null
CARRIER_VENDOR_SYSTEM_ID number 22  √  null
PO_NO varchar2 20  √  null
TRACKING_ID varchar2 40  √  null
PACKING_SLIP_NO varchar2 40  √  null
USER_ID number 22
USERS.USER_ID Implied Constraint R
USER_NAME varchar2 80
RECEIVED_TIME date 7
RECEIPT_ID number 20
RECEIPT_HEADER.RECEIPT_ID Implied Constraint R
ACCEPT_RECEIPT char 1
DELIV_LOC_ID number 22  √  null
DELIVERY_TICKET_ID varchar2 40  √  null
DELIVERY_TICKET.DELIVERY_TICKET_ID Implied Constraint R
DELIVERY_UNIT_NO number 4  √  null
VENDOR_SYSTEM_ID number 22  √  null
VENDOR.VENDOR_SYSTEM_ID Implied Constraint R
NOTE_ID number 20  √  null
NOTE.NOTE_ID Implied Constraint R
LAST_MODIFIED_DT date 7
DELIV_COMP_NO number 4  √  null

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT RD.DISTRIB_LINE_NO, L.LOCATION_ID, L.LOCATION_CODE, NVL(LTM.ALT_LOCATION_NAME, L.NAME), R.CARRIER_VENDOR_SYSTEM_ID, RL.PO_NO, R.TRACKING_NO, RL.PACKING_SLIP_NO, R.USER_ID, U.NAME, RL.RECEIVED_TIME, R.RECEIPT_ID, R.ACCEPT_RECEIPT, RD.DELIVERY_LOCATION_ID, RD.DELIVERY_TICKET_ID, RD.DELIVERY_UNIT_NO, R.VENDOR_SYSTEM_ID, R.NOTE_ID, R.LAST_MODIFIED_DT, RD.DELIVERY_COMPANY_NO FROM RECEIPT_HEADER R, RECEIPT_LINE RL, RECEIPT_LINE_DISTRIB RD, LOCATION_TYPE_MAP LTM, LOCATION L, USERS U WHERE R.RECEIPT_ID = RL.RECEIPT_ID AND RL.RECEIPT_ID = RD.RECEIPT_ID AND RL.RECEIPT_LINE_NO = RD.RECEIPT_LINE_NO AND L.LOCATION_ID = R.RECV_LOCATION_ID AND LTM.LOCATION_ID = L.LOCATION_ID AND LTM.LOCATION_TYPE_ID = 11 AND U.USER_ID = R.USER_ID AND R.STATUS = '0'
 
Possibly Referenced Tables/Views:
LOCATION LOCATION_TYPE_MAP RECEIPT_HEADER RECEIPT_LINE RECEIPT_LINE_DISTRIB USERS 


Close relationships: