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 89: INTO OKS_INT_HEADER_STG_TEMP

85: END IF;
86:
87: INSERT ALL
88: WHEN (1 = 1) THEN
89: INTO OKS_INT_HEADER_STG_TEMP
90: (HEADER_INTERFACE_ID
91: ,HEADER_INTERFACE_ROWID
92: ,CONTRACT_NUMBER
93: ,CONTRACT_NUMBER_MODIFIER

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

1016: WHERE ROWID between P_rowid_from AND P_rowid_to
1017: AND batch_id = P_batch_id
1018: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R');
1019:
1020: SELECT count(1) INTO l_stg_count FROM OKS_INT_HEADER_STG_TEMP;
1021:
1022: fnd_log.string(fnd_log.level_statement,
1023: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,
1024: 'Number of records in interface table being processed = ' || l_int_count ||', '||

Line 1600: FROM OKS_INT_HEADER_STG_TEMP HST

1596: THEN 'N' ELSE 'Y' END) REN_EST_DURPER_VALID
1597: ,(CASE WHEN ((HST.RENEWAL_ESTIMATED_PERIOD IS NOT NULL OR HST.RENEWAL_ESTIMATED_DURATION IS NOT NULL)
1598: AND HST.RENEWAL_ESTIMATED_PERCENT IS NULL)
1599: THEN 'Y' ELSE 'N' END) REN_EST_DURPER_NULL_ERROR
1600: FROM OKS_INT_HEADER_STG_TEMP HST
1601: ,OKC_SUBCLASSES_B CAT
1602: ,OKC_K_HEADERS_ALL_B HDR
1603: ,OKC_STATUSES_B STS
1604: ,FND_LOOKUPS RENP

Line 1917: FROM OKS_INT_HEADER_STG_TEMP HST

1913: ,(CASE WHEN COUNT(DISTINCT QAC.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1914: THEN 'N' ELSE 'Y' END) QAC_V
1915: ,(CASE WHEN COUNT(DISTINCT AP.ROWID) OVER (PARTITION BY HST.ROWID) <> 1
1916: THEN 'N' ELSE 'Y' END) AP_V
1917: FROM OKS_INT_HEADER_STG_TEMP HST
1918: ,HZ_CUST_ACCT_SITES_ALL QPS
1919: ,HZ_CUST_ACCOUNT_ROLES QTC
1920: ,HZ_CONTACT_POINTS QTP
1921: ,HZ_CONTACT_POINTS QTF

Line 2217: FROM OKS_INT_HEADER_STG_TEMP HST

2213: ,(CASE WHEN HST.SOURCE IS NOT NULL
2214: AND COUNT(DISTINCT SRC.ROWID) OVER (PARTITION BY HST.ROWID) = 0
2215: THEN 'N' ELSE 'Y' END) SOURCE_V
2216: ,COUNT(DISTINCT HOI.ROWID) OVER (PARTITION BY HST.ROWID) HOI_COUNT
2217: FROM OKS_INT_HEADER_STG_TEMP HST
2218: ,FND_LOOKUPS TEC
2219: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2220: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2221: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)

Line 2725: ,OKS_INT_HEADER_STG_TEMP HDR

2721: END)
2722: ELSE NULL
2723: END) LAST_BILL_FROM_DATE
2724: FROM OKS_LINES_INTERFACE OLI
2725: ,OKS_INT_HEADER_STG_TEMP HDR
2726: ,FND_LOOKUPS FL
2727: ,RA_CUSTOMER_TRX_ALL CNI
2728: ,FND_LOOKUPS PMC
2729: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID

Line 2806: ,OKS_INT_HEADER_STG_TEMP HST

2802: ,MAX(BCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) BCN_ID -- Billing contact id based on Name
2803: ,COUNT(DISTINCT SCN.ROW_ID) OVER (PARTITION BY LNI.ROWID) SCN_COUNT
2804: ,MAX(SCN.CONTACT_ID) OVER (PARTITION BY LNI.ROWID) SCN_ID -- Shipping contact id based on Name */
2805: FROM OKS_LINES_INTERFACE LNI
2806: ,OKS_INT_HEADER_STG_TEMP HST
2807: ,QP_LIST_HEADERS_B QPI
2808: ,(SELECT QP.ROWID ROW_ID, QPTL.NAME, QP.CURRENCY_CODE, QP.LIST_HEADER_ID
2809: FROM QP_LIST_HEADERS_B QP, QP_LIST_HEADERS_TL QPTL
2810: WHERE QP.LIST_HEADER_ID = QPTL.LIST_HEADER_ID

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

2850: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2851: ,HZ_CUST_SITE_USES_ALL BTSUI
2852: ,HZ_CUST_SITE_USES_ALL STSUI
2853: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2854: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2855: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2856: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

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

2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2859: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2860: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2861: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2862: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2863: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2864: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2865: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

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

2906:
2907: IF G_STMT_LOG THEN
2908:
2909: SELECT count(1) INTO l_int_count FROM OKS_LINES_INTERFACE OLI
2910: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
2911: WHERE HEADER_INTERFACE_ID = OLI.HEADER_INTERFACE_ID);
2912:
2913: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;
2914: /* to avoid gscc failure */

Line 3310: ,OKS_INT_HEADER_STG_TEMP HDR

3306: ,(CASE WHEN LST.LINE_TYPE = 'SUBSCRIPTION'
3307: AND COUNT(DISTINCT TANGIBLE.ROWID) OVER (PARTITION BY LST.ROWID) = 1
3308: THEN 'Y' ELSE 'N' END) TANGIBLE_SUB
3309: FROM OKS_INT_LINE_STG_TEMP LST
3310: ,OKS_INT_HEADER_STG_TEMP HDR
3311: ,HR_ORGANIZATION_INFORMATION HOI
3312: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3313: ,OKC_STATUSES_B STS
3314: ,OKC_STATUSES_B HDRSTS

Line 3739: ,OKS_INT_HEADER_STG_TEMP HDR

3735: WHEN LST.LINE_TYPE = 'SUBSCRIPTION' AND LST.LAST_BILLED_AMOUNT IS NOT NULL
3736: AND LST.LAST_BILL_FROM_DATE > LST.END_DATE THEN 'N'
3737: ELSE 'Y' END) LAST_BILL_DATE_V
3738: FROM OKS_INT_LINE_STG_TEMP LST
3739: ,OKS_INT_HEADER_STG_TEMP HDR
3740: ,OKC_TIME_CODE_UNITS_B BIP
3741: ,MTL_UNITS_OF_MEASURE SUOM
3742: ,OKC_TIME_CODE_UNITS_B PUOM
3743: ,OKC_TIME_CODE_UNITS_B USGP

Line 5468: ,OKS_INT_HEADER_STG_TEMP HDR

5464: AND (SALESPERSON_ID = OSC.SALESPERSON_ID OR SALESPERSON_NAME = OSC.SALESPERSON_NAME)
5465: AND SALES_CREDIT_TYPE = OSC.SALES_CREDIT_TYPE)
5466: THEN 'N' ELSE 'Y' END) UNIQ
5467: FROM OKS_SALES_CREDITS_INTERFACE OSC
5468: ,OKS_INT_HEADER_STG_TEMP HDR
5469: ,OE_SALES_CREDIT_TYPES SCT
5470: ,(SELECT distinct(OSCI.SALES_CREDIT_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
5471: ,(CASE WHEN COUNT(DISTINCT SPI.ROWID) OVER (PARTITION BY OSCI.ROW_ID) = 1
5472: THEN MAX(OSCI.SALESPERSON_ID) OVER (PARTITION BY OSCI.ROW_ID) -- Sales Person Id Based on Id

Line 5479: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST

5475: ELSE NULL
5476: END) SALESPERSON_ID
5477: FROM (SELECT SCI.ROWID ROW_ID, SCI.SALES_CREDIT_INTERFACE_ID, SCI.SALESPERSON_NAME, SCI.SALESPERSON_ID,
5478: SCI.SALESGROUP_ID, SCI.SALES_CREDIT_TYPE, SCI.PERCENT, HST.OPERATING_UNIT_ID
5479: FROM OKS_SALES_CREDITS_INTERFACE SCI, OKS_INT_HEADER_STG_TEMP HST
5480: WHERE SCI.HEADER_INTERFACE_ID = HST.HEADER_INTERFACE_ID) OSCI
5481: ,JTF_RS_SALESREPS SPI
5482: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
5483: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

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

5493:
5494: IF G_STMT_LOG THEN
5495:
5496: SELECT count(1) INTO l_int_count FROM OKS_SALES_CREDITS_INTERFACE OSCI
5497: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5498: WHERE HEADER_INTERFACE_ID = OSCI.HEADER_INTERFACE_ID);
5499:
5500: SELECT count(1) INTO l_stg_count FROM OKS_INT_SALES_CREDIT_STG_TEMP;
5501:

Line 5644: ,OKS_INT_HEADER_STG_TEMP OHSTG

5640: ELSE 'Y'
5641: END) ENTERED_DT_VALID
5642:
5643: FROM OKS_NOTES_INTERFACE ONI
5644: ,OKS_INT_HEADER_STG_TEMP OHSTG
5645: ,FND_LOOKUPS NTSTATUS
5646: ,FND_LOOKUPS NTTYPE
5647: ,FND_USER USR
5648:

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

5773: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5774: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5775:
5776: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI
5777: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5778: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5779: AND ONI.LINE_INTERFACE_ID IS NULL;
5780:
5781: fnd_log.string(fnd_log.level_statement,