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 2291: INTO OKS_INT_LINE_STG_TEMP

2287: END IF;
2288:
2289: INSERT ALL
2290: WHEN (1 = 1) THEN
2291: INTO OKS_INT_LINE_STG_TEMP
2292: (LINE_INTERFACE_ID
2293: ,LINE_NUMBER
2294: ,HEADER_INTERFACE_ID
2295: ,HEADER_INTERFACE_ROWID

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

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

Line 3237: OR EXISTS (SELECT 1 FROM OKS_INT_LINE_STG_TEMP LUNIQ

3233: ,NULL)
3234: SELECT LST.LINE_INTERFACE_ID LINE_INTERFACE_ID
3235: ,HDR.HEADER_INTERFACE_ROWID HEADER_INTERFACE_ROWID
3236: ,(CASE WHEN LST.LINE_NUMBER IS NULL
3237: OR EXISTS (SELECT 1 FROM OKS_INT_LINE_STG_TEMP LUNIQ
3238: WHERE LST.LINE_INTERFACE_ID <> LUNIQ.LINE_INTERFACE_ID
3239: AND LST.LINE_NUMBER = LUNIQ.LINE_NUMBER
3240: AND LST.HEADER_INTERFACE_ID = LUNIQ.HEADER_INTERFACE_ID)
3241: OR LST.LINE_NUMBER <= 0

Line 3309: FROM OKS_INT_LINE_STG_TEMP LST

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

Line 3738: FROM OKS_INT_LINE_STG_TEMP LST

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

Line 3833: ,OKS_INT_LINE_STG_TEMP OLSTG

3829: ,OCLI.STATUS_CODE STATUS_CODE
3830:
3831: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3832:
3833: ,OKS_INT_LINE_STG_TEMP OLSTG
3834:
3835: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3836: ,COUNT(DISTINCT CITMI.ROWID) OVER (PARTITION BY CLI.ROWID) CITMI_COUNT
3837: ,MAX(CLI.COVERED_INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMI_ID --INSTANCE ID Based on Id

Line 3891: ,OKS_INT_LINE_STG_TEMP OLSTG

3887: ,OCLI.COVERED_ITEM_ORG_ID COVERED_ITEM_ORG_ID
3888:
3889: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3890:
3891: ,OKS_INT_LINE_STG_TEMP OLSTG
3892:
3893: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3894: ,COUNT(DISTINCT CMSII.ROWID) OVER (PARTITION BY CLI.ROWID ) CMSII_COUNT
3895: ,MAX(CLI.COVERED_ITEM_ID ) OVER (PARTITION BY CLI.ROWID ) CMSII_ID --COVERED ITEM ID Based on Id

Line 3949: ,OKS_INT_LINE_STG_TEMP OLSTG

3945:
3946:
3947: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
3948:
3949: ,OKS_INT_LINE_STG_TEMP OLSTG
3950:
3951: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
3952: ,COUNT(DISTINCT HPI.ROWID) OVER (PARTITION BY CLI.ROWID) HPI_COUNT
3953: ,MAX(CLI.COVERED_PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPI_ID --COVERED PARTY ID Based on Id

Line 4006: ,OKS_INT_LINE_STG_TEMP OLSTG

4002: END) COVERED_ACCOUNT_ID
4003:
4004: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4005:
4006: ,OKS_INT_LINE_STG_TEMP OLSTG
4007:
4008: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
4009: ,COUNT(DISTINCT HCAI.ROWID) OVER (PARTITION BY CLI.ROWID) HCAI_COUNT
4010: ,MAX(CLI.COVERED_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAI_ID --COVERED ACCOUNT ID Based on Id

Line 4059: ,OKS_INT_LINE_STG_TEMP OLSTG

4055: END) COVERED_SITE_ID
4056:
4057: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4058:
4059: ,OKS_INT_LINE_STG_TEMP OLSTG
4060:
4061: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
4062:
4063: ,COUNT(DISTINCT CSITEID.ROWID) OVER (PARTITION BY CLI.ROWID) CSITEID_COUNT

Line 4109: ,OKS_INT_LINE_STG_TEMP OLSTG

4105: END) COVERED_SYSTEM_ID
4106:
4107: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4108:
4109: ,OKS_INT_LINE_STG_TEMP OLSTG
4110:
4111: ,(SELECT distinct (CLI.COVERED_LEVEL_INTERFACE_ID)
4112:
4113: ,COUNT(DISTINCT CSYSID.ROWID) OVER (PARTITION BY CLI.ROWID) CSYSID_COUNT

Line 4648: ,OKS_INT_LINE_STG_TEMP OLSTG

4644: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4645:
4646: ,OKS_COVERED_LEVELS_INTERFACE OCLIN
4647:
4648: ,OKS_INT_LINE_STG_TEMP OLSTG
4649:
4650: ,OKC_STATUSES_B STS
4651:
4652: ,FND_LOOKUPS CR1

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

4718:
4719: IF G_STMT_LOG THEN
4720:
4721: SELECT count(1) INTO l_int_count FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4722: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
4723: WHERE LINE_INTERFACE_ID = OCLI.LINE_INTERFACE_ID);
4724:
4725: SELECT count(1) INTO l_stg_count FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
4726: /* to avoid gscc failure */

Line 5243: ,OKS_INT_LINE_STG_TEMP OLSTG

5239: END ) CNTR_VALID_YN
5240:
5241: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5242: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5243: ,OKS_INT_LINE_STG_TEMP OLSTG
5244: ,FND_LOOKUPS ESTMTHD
5245: ,OKC_STATUSES_B STS
5246: ,FND_LOOKUPS CR1
5247: ,FND_LOOKUPS CR2

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

5263:
5264: IF G_STMT_LOG THEN
5265:
5266: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5267: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5268: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5269:
5270: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5271: /* to avoid gscc failure */

Line 5757: ,OKS_INT_LINE_STG_TEMP OLSTG

5753: ELSE 'Y'
5754: END) ENTERED_DT_VALID
5755:
5756: FROM OKS_NOTES_INTERFACE ONI
5757: ,OKS_INT_LINE_STG_TEMP OLSTG
5758: ,FND_LOOKUPS NTSTATUS
5759: ,FND_LOOKUPS NTTYPE
5760: ,FND_USER USR
5761:

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

5769:
5770: IF G_STMT_LOG THEN
5771:
5772: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
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