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_LINE_STG_TEMP

Line 2252: INTO OKS_INT_LINE_STG_TEMP

2248: l_stmt_num := 10;
2249:
2250: INSERT ALL
2251: WHEN (1 = 1) THEN
2252: INTO OKS_INT_LINE_STG_TEMP
2253: (LINE_INTERFACE_ID
2254: ,LINE_NUMBER
2255: ,HEADER_INTERFACE_ID
2256: ,HEADER_INTERFACE_ROWID

Line 2861: SELECT count(1) INTO l_stg_count FROM OKS_INT_LINE_STG_TEMP;

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 */
2863: IF G_STMT_LOG THEN
2864: fnd_log.string(fnd_log.level_statement,
2865: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,

Line 3185: OR EXISTS (SELECT 1 FROM OKS_INT_LINE_STG_TEMP LUNIQ

3181: ,NULL)
3182: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID
3183: ,HDR.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
3184: ,(CASE WHEN LST.LINE_NUMBER IS NULL
3185: OR EXISTS (SELECT 1 FROM OKS_INT_LINE_STG_TEMP LUNIQ
3186: WHERE LST.LINE_INTERFACE_ID <> LUNIQ.LINE_INTERFACE_ID
3187: AND LST.LINE_NUMBER = LUNIQ.LINE_NUMBER
3188: AND LST.HEADER_INTERFACE_ID = LUNIQ.HEADER_INTERFACE_ID)
3189: OR LST.LINE_NUMBER <= 0

Line 3257: FROM OKS_INT_LINE_STG_TEMP LST

3253: THEN 'Y' ELSE 'N' END) POREQ_NULL_ERROR
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

Line 3686: FROM OKS_INT_LINE_STG_TEMP LST

3682: ,(CASE WHEN LST.LAST_BILL_FROM_DATE - 1 > LST.END_DATE THEN 'N'
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

Line 3781: ,OKS_INT_LINE_STG_TEMP OLSTG

3777: ,OCLI.STATUS_CODE STATUS_CODE
3778:
3779: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3780:
3781: ,OKS_INT_LINE_STG_TEMP OLSTG
3782:
3783: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3784: ,COUNT(DISTINCT CITMI.ROWID) OVER (PARTITION BY CLI.ROWID) CITMI_COUNT
3785: ,MAX(CLI.COVERED_INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMI_ID --INSTANCE ID Based on Id

Line 3839: ,OKS_INT_LINE_STG_TEMP OLSTG

3835: ,OCLI.COVERED_ITEM_ORG_ID COVERED_ITEM_ORG_ID
3836:
3837: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3838:
3839: ,OKS_INT_LINE_STG_TEMP OLSTG
3840:
3841: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3842: ,COUNT(DISTINCT CMSII.ROWID) OVER (PARTITION BY CLI.ROWID ) CMSII_COUNT
3843: ,MAX(CLI.COVERED_ITEM_ID ) OVER (PARTITION BY CLI.ROWID ) CMSII_ID --COVERED ITEM ID Based on Id

Line 3897: ,OKS_INT_LINE_STG_TEMP OLSTG

3893:
3894:
3895: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3896:
3897: ,OKS_INT_LINE_STG_TEMP OLSTG
3898:
3899: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3900: ,COUNT(DISTINCT HPI.ROWID) OVER (PARTITION BY CLI.ROWID) HPI_COUNT
3901: ,MAX(CLI.COVERED_PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPI_ID --COVERED PARTY ID Based on Id

Line 3954: ,OKS_INT_LINE_STG_TEMP OLSTG

3950: END) COVERED_ACCOUNT_ID
3951:
3952: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3953:
3954: ,OKS_INT_LINE_STG_TEMP OLSTG
3955:
3956: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3957: ,COUNT(DISTINCT HCAI.ROWID) OVER (PARTITION BY CLI.ROWID) HCAI_COUNT
3958: ,MAX(CLI.COVERED_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAI_ID --COVERED ACCOUNT ID Based on Id

Line 4007: ,OKS_INT_LINE_STG_TEMP OLSTG

4003: END) COVERED_SITE_ID
4004:
4005: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4006:
4007: ,OKS_INT_LINE_STG_TEMP OLSTG
4008:
4009: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
4010:
4011: ,COUNT(DISTINCT CSITEID.ROWID) OVER (PARTITION BY CLI.ROWID) CSITEID_COUNT

Line 4057: ,OKS_INT_LINE_STG_TEMP OLSTG

4053: END) COVERED_SYSTEM_ID
4054:
4055: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4056:
4057: ,OKS_INT_LINE_STG_TEMP OLSTG
4058:
4059: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
4060:
4061: ,COUNT(DISTINCT CSYSID.ROWID) OVER (PARTITION BY CLI.ROWID) CSYSID_COUNT

Line 4522: ,OKS_INT_LINE_STG_TEMP OLSTG

4518: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4519:
4520: ,OKS_COVERED_LEVELS_INTERFACE OCLIN
4521:
4522: ,OKS_INT_LINE_STG_TEMP OLSTG
4523:
4524: ,OKC_STATUSES_B STS
4525:
4526: ,FND_LOOKUPS CR1

Line 4596: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP

4592:
4593: IF G_STMT_LOG THEN
4594:
4595: SELECT count(1) INTO l_int_count FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4596: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
4597: WHERE LINE_INTERFACE_ID = OCLI.LINE_INTERFACE_ID);
4598:
4599: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4600: /* to avoid gscc failure */

Line 5117: ,OKS_INT_LINE_STG_TEMP OLSTG

5113: END ) CNTR_VALID_YN
5114:
5115: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5116: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5117: ,OKS_INT_LINE_STG_TEMP OLSTG
5118: ,FND_LOOKUPS ESTMTHD
5119: ,OKC_STATUSES_B STS
5120: ,FND_LOOKUPS CR1
5121: ,FND_LOOKUPS CR2

Line 5141: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP

5137:
5138: IF G_STMT_LOG THEN
5139:
5140: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5141: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5142: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5143:
5144: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5145: /* to avoid gscc failure */

Line 5613: ,OKS_INT_LINE_STG_TEMP OLSTG

5609: ELSE 'Y'
5610: END) ENTERED_DT_VALID
5611:
5612: FROM OKS_NOTES_INTERFACE ONI
5613: ,OKS_INT_LINE_STG_TEMP OLSTG
5614: ,FND_LOOKUPS NTSTATUS
5615: ,FND_LOOKUPS NTTYPE
5616: ,FND_USER USR
5617:

Line 5629: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP

5625:
5626: IF G_STMT_LOG THEN
5627:
5628: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
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