DOO_CVRD_FLINE_UNREF_RETRN

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

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'

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'