DOO_CVRD_FLINE_UNREF_RETRN_V
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
DOC_SYSTEM_REF_ID DOCUMENT_HEADER_ID DOCUMENT_LINE_ID DOCUMENT_FULFILL_LINE_ID OWNER_TABLE_ID DOC_REF_TYPE DOC_ID DOC_CONTEXT_ID DOC_USER_KEY DOC_ALT_USER_KEY DOC_LINE_ID DOC_LINE_CONTEXT_ID DOC_LINE_USER_KEY DOC_LINE_ALT_USER_KEY DOC_SUBLINE_ID DOC_SUBLINE_CONTEXT_ID DOC_SUBLINE_USER_KEY DOC_SUBLINE_ALT_USER_KEY REFERENCE_DOC_SYSTEM_REF_ID TASK_TYPE FLINE_FULFILL_LINE_ID RECEIVABLES_ORG_ID FLINE_HEADER_ID FLINE_LINE_ID INVENTORY_ITEM_ID STATUS_CODE OWNER_ID BILL_TO_CONTACT_ID BILL_TO_CUSTOMER_ID BILL_TO_SITE_USE_ID SOURCE_ORG_ID ORG_ID CARRIER_ID INVOICING_RULE_ID ACCOUNTING_RULE_ID CATEGORY_CODE OPEN_FLAG ORIGINAL_INVENTORY_ITEM_ID GOP_REFERENCE_ID PARENT_FULFILL_LINE_ID PAYMENT_TERM_ID REQUEST_TYPE RETURN_REASON_CODE ROOT_PARENT_FULFILL_LINE_ID SHIP_TO_CONTACT_ID SHIP_TO_CUSTOMER_ID SHIP_TO_SITE_USE_ID SPLIT_FROM_FLINE_ID REFERENCE_FLINE_ID INVENTORY_ORGANIZATION_ID FULFILL_INSTANCE_ID PROCESS_INSTANCE_ID BILLING_TRX_TYPE_ID |
Query
SQL_Statement |
---|
SELECT DOO_DOCUMENT_REFERENCES.DOC_SYSTEM_REF_ID, DOO_DOCUMENT_REFERENCES.HEADER_ID DOCUMENT_HEADER_ID, DOO_DOCUMENT_REFERENCES.LINE_ID DOCUMENT_LINE_ID, DOO_DOCUMENT_REFERENCES.FULFILL_LINE_ID DOCUMENT_FULFILL_LINE_ID, DOO_DOCUMENT_REFERENCES.OWNER_TABLE_ID, DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE, DOO_DOCUMENT_REFERENCES.DOC_ID, DOO_DOCUMENT_REFERENCES.DOC_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_LINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_LINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_CONTEXT_ID, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_USER_KEY, DOO_DOCUMENT_REFERENCES.DOC_SUBLINE_ALT_USER_KEY, DOO_DOCUMENT_REFERENCES.REFERENCE_DOC_SYSTEM_REF_ID, DOO_DOCUMENT_REFERENCES.TASK_TYPE, DOO_FULFILL_LINES_ALL.FULFILL_LINE_ID FLINE_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.RECEIVABLES_ORG_ID, DOO_FULFILL_LINES_ALL.HEADER_ID FLINE_HEADER_ID, DOO_FULFILL_LINES_ALL.LINE_ID FLINE_LINE_ID, DOO_FULFILL_LINES_ALL.INVENTORY_ITEM_ID, DOO_FULFILL_LINES_ALL.STATUS_CODE, DOO_FULFILL_LINES_ALL.OWNER_ID, DOO_FULFILL_LINES_ALL.BILL_TO_CONTACT_ID, DOO_FULFILL_LINES_ALL.BILL_TO_CUSTOMER_ID, DOO_FULFILL_LINES_ALL.BILL_TO_SITE_USE_ID, DOO_FULFILL_LINES_ALL.SOURCE_ORG_ID, DOO_FULFILL_LINES_ALL.ORG_ID, DOO_FULFILL_LINES_ALL.CARRIER_ID, DOO_FULFILL_LINES_ALL.INVOICING_RULE_ID, DOO_FULFILL_LINES_ALL.ACCOUNTING_RULE_ID, DOO_FULFILL_LINES_ALL.CATEGORY_CODE, DOO_FULFILL_LINES_ALL.OPEN_FLAG, DOO_FULFILL_LINES_ALL.ORIGINAL_INVENTORY_ITEM_ID, DOO_FULFILL_LINES_ALL.GOP_REFERENCE_ID, DOO_FULFILL_LINES_ALL.PARENT_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.PAYMENT_TERM_ID, DOO_FULFILL_LINES_ALL.REQUEST_TYPE, DOO_FULFILL_LINES_ALL.RETURN_REASON_CODE, DOO_FULFILL_LINES_ALL.ROOT_PARENT_FULFILL_LINE_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_CONTACT_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_CUSTOMER_ID, DOO_FULFILL_LINES_ALL.SHIP_TO_SITE_USE_ID, DOO_FULFILL_LINES_ALL.SPLIT_FROM_FLINE_ID, DOO_FULFILL_LINES_ALL.REFERENCE_FLINE_ID, DOO_FULFILL_LINES_ALL.INVENTORY_ORGANIZATION_ID, DOO_FULFILL_LINES_ALL.FULFILL_INSTANCE_ID, DOO_FULFILL_LINES_ALL.PROCESS_INSTANCE_ID, DOO_FULFILL_LINES_ALL.BILLING_TRX_TYPE_ID FROM fusion.DOO_FULFILL_LINES_ALL,fusion.DOO_DOCUMENT_REFERENCES WHERE DOO_FULFILL_LINES_ALL.FULFILL_LINE_ID=DOO_DOCUMENT_REFERENCES.FULFILL_LINE_ID AND DOO_DOCUMENT_REFERENCES.DOC_REF_TYPE='COVERED_ITEM_FOR_ADHOC_RTN' |