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.

APPS.OKS_IMPORT_VALIDATE dependencies on OKS_INT_HEADER_STG_TEMP

Line 71: INTO OKS_INT_HEADER_STG_TEMP

67: l_stmt_num := 10;
68:
69: INSERT ALL
70: WHEN (1 = 1) THEN
71: INTO OKS_INT_HEADER_STG_TEMP
72: (HEADER_INTERFACE_ID
73: ,HEADER_INTERFACE_ROWID
74: ,CONTRACT_NUMBER
75: ,CONTRACT_NUMBER_MODIFIER

Line 990: SELECT count(1) INTO l_stg_count FROM OKS_INT_HEADER_STG_TEMP;

986: WHERE ROWID between P_rowid_from AND P_rowid_to
987: AND batch_id = P_batch_id
988: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
989:
990: SELECT count(1) INTO l_stg_count FROM OKS_INT_HEADER_STG_TEMP;
991:
992: fnd_log.string(fnd_log.level_statement,
993: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
994: 'Number of records in interface table being processed = ' || l_int_count ||', '||

Line 1570: FROM OKS_INT_HEADER_STG_TEMP HST

1566: THEN 'N' ELSE 'Y' END) REN_EST_DURPER_VALID
1567: ,(CASE WHEN ((HST.RENEWAL_ESTIMATED_PERIOD IS NOT NULL OR HST.RENEWAL_ESTIMATED_DURATION IS NOT NULL)
1568: AND HST.RENEWAL_ESTIMATED_PERCENT IS NULL)
1569: THEN 'Y' ELSE 'N' END) REN_EST_DURPER_NULL_ERROR
1570: FROM OKS_INT_HEADER_STG_TEMP HST
1571: ,OKC_SUBCLASSES_B CAT
1572: ,OKC_K_HEADERS_ALL_B HDR
1573: ,OKC_STATUSES_B STS
1574: ,FND_LOOKUPS RENP

Line 1887: FROM OKS_INT_HEADER_STG_TEMP HST

1883: ,(CASE WHEN COUNT(DISTINCT QAC.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1884: THEN 'N' ELSE 'Y' END) QAC_V
1885: ,(CASE WHEN COUNT(DISTINCT AP.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1886: THEN 'N' ELSE 'Y' END) AP_V
1887: FROM OKS_INT_HEADER_STG_TEMP HST
1888: ,HZ_CUST_ACCT_SITES_ALL QPS
1889: ,HZ_CUST_ACCOUNT_ROLES QTC
1890: ,HZ_CONTACT_POINTS QTP
1891: ,HZ_CONTACT_POINTS QTF

Line 2187: FROM OKS_INT_HEADER_STG_TEMP HST

2183: ,(CASE WHEN HST.SOURCE IS NOT NULL
2184: AND COUNT(DISTINCT SRC.ROWID) OVER (PARTITION BY HST.ROWID) = 0
2185: THEN 'N' ELSE 'Y' END) SOURCE_V
2186: ,COUNT(DISTINCT HOI.ROWID) OVER (PARTITION BY HST.ROWID) HOI_COUNT
2187: FROM OKS_INT_HEADER_STG_TEMP HST
2188: ,FND_LOOKUPS TEC
2189: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2190: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2191: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)

Line 2683: ,OKS_INT_HEADER_STG_TEMP HDR

2679: END)
2680: ELSE NULL
2681: END) LAST_BILL_FROM_DATE
2682: FROM OKS_LINES_INTERFACE OLI
2683: ,OKS_INT_HEADER_STG_TEMP HDR
2684: ,FND_LOOKUPS FL
2685: ,RA_CUSTOMER_TRX_ALL CNI
2686: ,FND_LOOKUPS PMC
2687: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID

Line 2758: ,OKS_INT_HEADER_STG_TEMP HST

2754: ,MAX(BCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) BCN_ID -- Billing contact id based on Name
2755: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2756: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2757: FROM OKS_LINES_INTERFACE LNI
2758: ,OKS_INT_HEADER_STG_TEMP HST
2759: ,QP_LIST_HEADERS_B QPI
2760: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2761: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2762: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID

Line 2806: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT

2802: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2803: ,HZ_CUST_SITE_USES_ALL BTSUI
2804: ,HZ_CUST_SITE_USES_ALL STSUI
2805: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2806: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2807: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2808: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

Line 2813: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT

2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2811: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2812: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2813: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2814: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2815: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2816: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2817: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

Line 2858: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP

2854:
2855: IF G_STMT_LOG THEN
2856:
2857: SELECT count(1) INTO l_int_count FROM OKS_LINES_INTERFACE OLI
2858: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
2859: WHERE HEADER_INTERFACE_ID = OLI.HEADER_INTERFACE_ID);
2860:
2861: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;
2862: /* to avoid gscc failure */

Line 3258: ,OKS_INT_HEADER_STG_TEMP HDR

3254: ,(CASE WHEN LST.LINE_TYPE = 'SUBSCRIPTION'
3255: AND COUNT(DISTINCT TANGIBLE.ROWID) OVER (PARTITION BY LST.ROWID) = 1
3256: THEN 'Y' ELSE 'N' END) TANGIBLE_SUB
3257: FROM OKS_INT_LINE_STG_TEMP LST
3258: ,OKS_INT_HEADER_STG_TEMP HDR
3259: ,HR_ORGANIZATION_INFORMATION HOI
3260: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3261: ,OKC_STATUSES_B STS
3262: ,OKC_STATUSES_B HDRSTS

Line 3687: ,OKS_INT_HEADER_STG_TEMP HDR

3683: WHEN LST.LINE_TYPE = 'SUBSCRIPTION' AND LST.LAST_BILLED_AMOUNT IS NOT NULL
3684: AND LST.LAST_BILL_FROM_DATE > LST.END_DATE THEN 'N'
3685: ELSE 'Y' END) LAST_BILL_DATE_V
3686: FROM OKS_INT_LINE_STG_TEMP LST
3687: ,OKS_INT_HEADER_STG_TEMP HDR
3688: ,OKC_TIME_CODE_UNITS_B BIP
3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP

Line 5324: ,OKS_INT_HEADER_STG_TEMP HDR

5320: AND (SALESPERSON_ID = OSC.SALESPERSON_ID OR SALESPERSON_NAME = OSC.SALESPERSON_NAME)
5321: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)
5322: THEN 'N' ELSE 'Y' END) UNIQ
5323: FROM OKS_SALES_CREDITS_INTERFACE OSC
5324: ,OKS_INT_HEADER_STG_TEMP HDR
5325: ,OE_SALES_CREDIT_TYPES SCT
5326: ,(SELECT distinct(OSCI.SALES_CREDIT_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
5327: ,(CASE WHEN COUNT(DISTINCT SPI.ROWID) OVER (PARTITION BY OSCI.ROW_ID) = 1
5328: THEN MAX(OSCI.SALESPERSON_ID) OVER (PARTITION BY OSCI.ROW_ID) -- Sales Person Id Based on Id

Line 5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST

5331: ELSE NULL
5332: END) SALESPERSON_ID
5333: FROM (SELECT SCI.ROWID ROW_ID, SCI.SALES_CREDIT_INTERFACE_ID, SCI.SALESPERSON_NAME, SCI.SALESPERSON_ID,
5334: SCI.SALESGROUP_ID, SCI.SALES_CREDIT_TYPE, SCI.PERCENT, HST.OPERATING_UNIT_ID
5335: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5336: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5337: ,JTF_RS_SALESREPS SPI
5338: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5339: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

Line 5353: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP

5349:
5350: IF G_STMT_LOG THEN
5351:
5352: SELECT count(1) INTO l_int_count FROM OKS_SALES_CREDITS_INTERFACE OSCI
5353: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5354: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5355:
5356: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;
5357:

Line 5500: ,OKS_INT_HEADER_STG_TEMP OHSTG

5496: ELSE 'Y'
5497: END) ENTERED_DT_VALID
5498:
5499: FROM OKS_NOTES_INTERFACE ONI
5500: ,OKS_INT_HEADER_STG_TEMP OHSTG
5501: ,FND_LOOKUPS NTSTATUS
5502: ,FND_LOOKUPS NTTYPE
5503: ,FND_USER USR
5504:

Line 5633: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP

5629: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5630: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5631:
5632: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI
5633: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5634: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5635: AND ONI.LINE_INTERFACE_ID IS NULL;
5636:
5637: fnd_log.string(fnd_log.level_statement,