View: OE_SALES_CONTINGENCY_RM_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_SALES_CONTINGENCY_RM_V

View Text

SELECT 'SALESCREDITS' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OESC.SALES_CREDIT_ID DOC_SUB_LINE_ID_INT_1
, OEL.LINE_ID DOC_SUB_LINE_ID_INT_2
, OESC.LINE_ID DOC_LINE_ID_INT_1
, OESC.HEADER_ID DOC_ID_INT_1
, OESC.CREATION_DATE SUB_LINE_CREATION_DATE
, OESC.LAST_UPDATE_DATE SUB_LINE_LAST_UPDATE_DATE
, JTF.GL_ID_REV CODE_COMBINATION_ID
, OESC.SALESREP_ID
, JTF.NAME SALESREP_NAME
, OESC.PERCENT REVENUE_PERCENT_SPLIT
, OESC.SALES_CREDIT_TYPE_ID
, OEL.ORG_ID
, NULL LINE_NUMBER
, NULL CONTINGENCY_NAME
, NULL CONTINGENCY_ID
, NULL EXPIRATION_DATE
, NULL EXPIRATION_DAYS
, NULL EXPIRED_FLAG
, NULL EXPIRATION_EVENT_DATE
, NULL EXPIRED_BY
, NULL COMMENTS FROM OE_SALES_CREDITS OESC
, JTF_RS_SALESREPS JTF
, OE_ORDER_LINES_ALL OEL WHERE OESC.SALESREP_ID= JTF.SALESREP_ID AND OEL.HEADER_ID= OESC.HEADER_ID AND OEL.LINE_ID = OESC.LINE_ID AND JTF.ORG_ID= OEL.ORG_ID AND OESC.LINE_ID IS NOT NULL UNION SELECT 'SALESCREDITS' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OESC.SALES_CREDIT_ID DOC_SUB_LINE_ID_INT_1
, OEL.LINE_ID DOC_SUB_LINE_ID_INT_2
, OEL.LINE_ID DOC_LINE_ID_INT_1
, OESC.HEADER_ID DOC_ID_INT_1
, OESC.CREATION_DATE SUB_LINE_CREATION_DATE
, OESC.LAST_UPDATE_DATE SUB_LINE_LAST_UPDATE_DATE
, JTF.GL_ID_REV CODE_COMBINATION_ID
, OESC.SALESREP_ID
, JTF.NAME SALESREP_NAME
, OESC.PERCENT REVENUE_PERCENT_SPLIT
, OESC.SALES_CREDIT_TYPE_ID
, OEL.ORG_ID
, NULL LINE_NUMBER
, NULL CONTINGENCY_NAME
, NULL CONTINGENCY_ID
, NULL EXPIRATION_DATE
, NULL EXPIRATION_DAYS
, NULL EXPIRED_FLAG
, NULL EXPIRATION_EVENT_DATE
, NULL EXPIRED_BY
, NULL COMMENTS FROM OE_SALES_CREDITS OESC
, JTF_RS_SALESREPS JTF
, OE_ORDER_LINES_ALL OEL WHERE OESC.SALESREP_ID= JTF.SALESREP_ID AND OEL.HEADER_ID= OESC.HEADER_ID AND JTF.ORG_ID= OEL.ORG_ID AND OESC.LINE_ID IS NULL AND OEL.LINE_ID NOT IN ( SELECT LINE_ID FROM OE_SALES_CREDITS OESC1 WHERE OESC1.LINE_ID=OEL.LINE_ID AND OESC1.HEADER_ID=OEL.HEADER_ID AND OESC1.LINE_ID IS NOT NULL) UNION SELECT 'CONTINGENCIES' DOC_SUB_LINE_TYPE
, 'L' DOC_SUB_LINE_LEVEL
, OEL.LINE_ID DOC_SUB_LINE_ID_INT_1
, -99 DOC_SUB_LINE_ID_INT_2
, OEL.LINE_ID DOC_LINE_ID_INT_1
, OEL.HEADER_ID DOC_ID_INT_1
, OEL.CREATION_DATE SUB_LINE_CREATION_DATE
, OEL.LAST_UPDATE_DATE SUB_LINE_LAST_UPDATE_DATE
, NULL CODE_COMBINATION_ID
, NULL SALESREP_ID
, NULL SALESREP_NAME
, NULL REVENUE_PERCENT_SPLIT
, NULL SALES_CREDIT_TYPE_ID
, OEL.ORG_ID
, OEL.LINE_NUMBER
, ADR.CONTINGENCY_NAME
, OEL.CONTINGENCY_ID
, (OEL.ACTUAL_SHIPMENT_DATE+OEL.REVREC_EXPIRATION_DAYS) EXPIRATION_DATE
, OEL.REVREC_EXPIRATION_DAYS EXPIRATION_DAYS
, DECODE(NVL(OEL.ACCEPTED_QUANTITY
, 0)
, 0
, 'N'
, 'Y') EXPIRED_FLAG
, OEL.ACTUAL_SHIPMENT_DATE EXPIRATION_EVENT_DATE
, OEL.ACCEPTED_BY EXPIRED_BY
, OEL.REVREC_COMMENTS COMMENTS FROM OE_ORDER_LINES_ALL OEL
, AR_DEFERRAL_REASONS ADR WHERE OEL.CONTINGENCY_ID IS NOT NULL AND ADR.REVREC_EVENT_CODE IN ('INVOICING'
, 'CUSTOMER_ACCEPTANCE') AND ADR.CONTINGENCY_ID= OEL.CONTINGENCY_ID