eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.OE_SALES_CONTINGENCY_RM_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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