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_COVERED_LEVELS_INTERFACE

Line 3779: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3775: END) COVERED_INSTANCE_ID
3776:
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)

Line 3792: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3788:
3789: ,COUNT(DISTINCT CITMSER.ROWID) OVER (PARTITION BY CLI.ROWID) CITMSER_COUNT
3790: ,MAX(CITMSER.INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMSER_ID -- ITEM INSTANCE ID Based on Serial number
3791:
3792: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3793: ,CSI_ITEM_INSTANCES CITMI
3794: ,CSI_ITEM_INSTANCES CITMN
3795: ,CSI_ITEM_INSTANCES CITMSER
3796: WHERE CLI.COVERED_INSTANCE_ID = CITMI.INSTANCE_ID (+)

Line 3837: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3833: END) COVERED_ITEM_ID
3834:
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)

Line 3848: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3844:
3845: ,COUNT(DISTINCT CMSIN.ROWID) OVER (PARTITION BY CLI.ROWID) CMSIN_COUNT
3846: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3847:
3848: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3849: ,MTL_SYSTEM_ITEMS CMSII
3850: ,MTL_SYSTEM_ITEMS CMSIN
3851: WHERE CLI.COVERED_INSTANCE_ID = CMSII.INVENTORY_ITEM_ID (+)
3852: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)

Line 3895: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3891: ELSE NULL
3892: END) COVERED_PARTY_ID
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)

Line 3910: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3906:
3907: ,COUNT(DISTINCT HPIN.ROWID) OVER (PARTITION BY CLI.ROWID) HPIN_COUNT
3908: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3909:
3910: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3911: ,HZ_PARTIES HPI
3912: ,HZ_PARTIES HPINUM
3913: ,HZ_PARTIES HPIN
3914:

Line 3952: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3948: WHEN NAMEID_Q.HCAN_COUNT = 1 THEN NAMEID_Q.HCAN_ID
3949: ELSE NULL
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)

Line 3964: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3960: ,COUNT(DISTINCT HCAN.ROWID) OVER (PARTITION BY CLI.ROWID) HCAN_COUNT
3961: ,MAX(HCAN.CUST_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAN_ID -- COVERED ACCOUNT ID Based on Number
3962:
3963:
3964: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3965: ,HZ_CUST_ACCOUNTS HCAI
3966: ,HZ_CUST_ACCOUNTS HCAN
3967:
3968: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)

Line 4005: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

4001: WHEN NAMEID_Q.CSITENUM_COUNT =1 THEN NAMEID_Q.CSITENUM_ID
4002: ELSE NULL
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)

Line 4017: FROM OKS_COVERED_LEVELS_INTERFACE CLI

4013:
4014: ,COUNT(DISTINCT CSITENUM.ROWID) OVER (PARTITION BY CLI.ROWID) CSITENUM_COUNT
4015: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4016:
4017: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4018: ,HZ_PARTY_SITES CSITEID
4019: ,HZ_PARTY_SITES CSITENUM
4020:
4021: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)

Line 4055: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

4051: ,(CASE WHEN NAMEID_Q.CSYSID_COUNT =1 THEN NAMEID_Q.CSYSID_ID
4052: ELSE NULL
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)

Line 4064: FROM OKS_COVERED_LEVELS_INTERFACE CLI

4060:
4061: ,COUNT(DISTINCT CSYSID.ROWID) OVER (PARTITION BY CLI.ROWID) CSYSID_COUNT
4062: ,MAX(CLI.COVERED_SYSTEM_ID) OVER (PARTITION BY CLI.ROWID) CSYSID_ID --COVERED SYSTEM ID Based on Id
4063:
4064: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4065: ,CSI_SYSTEMS_B CSYSID
4066:
4067: WHERE CLI.COVERED_SYSTEM_ID = CSYSID.SYSTEM_ID (+)) NAMEID_Q
4068:

Line 4106: ,'OKS_COVERED_LEVELS_INTERFACE'

4102: ,ERROR_MSG
4103: ,MSG_TOKENS)
4104: VALUES (G_WORKER_REQ_ID
4105: ,HEADER_INTERFACE_ROWID
4106: ,'OKS_COVERED_LEVELS_INTERFACE'
4107: ,COVERED_LEVEL_INTERFACE_ID
4108: ,'OKS_IMP_CLVL_INVALID_LINTID'
4109: ,NULL )
4110: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN

Line 4120: ,'OKS_COVERED_LEVELS_INTERFACE'

4116: ,ERROR_MSG
4117: ,MSG_TOKENS)
4118: VALUES (G_WORKER_REQ_ID
4119: ,HEADER_INTERFACE_ROWID
4120: ,'OKS_COVERED_LEVELS_INTERFACE'
4121: ,COVERED_LEVEL_INTERFACE_ID
4122: ,'OKS_IMP_CLVL_INVALID_LINNUM'
4123: ,NULL)
4124: WHEN ( STATUS_CODE IS NULL OR STATUS_CLVL_VALID ='N' OR STATUS_LINLVL_VALID='N') THEN

Line 4134: ,'OKS_COVERED_LEVELS_INTERFACE'

4130: ,ERROR_MSG
4131: ,MSG_TOKENS)
4132: VALUES (G_WORKER_REQ_ID
4133: ,HEADER_INTERFACE_ROWID
4134: ,'OKS_COVERED_LEVELS_INTERFACE'
4135: ,COVERED_LEVEL_INTERFACE_ID
4136: ,'OKS_IMP_CLVL_INVALID_STSCODE'
4137: ,NULL)
4138: WHEN (DATE_CLVL_VALID ='N' OR DATE_LINLVL_VALID='N') THEN

Line 4148: ,'OKS_COVERED_LEVELS_INTERFACE'

4144: ,ERROR_MSG
4145: ,MSG_TOKENS)
4146: VALUES (G_WORKER_REQ_ID
4147: ,HEADER_INTERFACE_ROWID
4148: ,'OKS_COVERED_LEVELS_INTERFACE'
4149: ,COVERED_LEVEL_INTERFACE_ID
4150: ,'OKS_IMP_CLVL_INVALID_DTRANGE'
4151: ,NULL)
4152: WHEN (DATE_CLVL_STS_VALID ='N' ) THEN

Line 4162: ,'OKS_COVERED_LEVELS_INTERFACE'

4158: ,ERROR_MSG
4159: ,MSG_TOKENS)
4160: VALUES (G_WORKER_REQ_ID
4161: ,HEADER_INTERFACE_ROWID
4162: ,'OKS_COVERED_LEVELS_INTERFACE'
4163: ,COVERED_LEVEL_INTERFACE_ID
4164: ,'OKS_IMP_CLVL_INVALID_STS_DT'
4165: ,NULL)
4166: WHEN (ST_DT_FST_BILL_YN ='N' ) THEN

Line 4176: ,'OKS_COVERED_LEVELS_INTERFACE'

4172: ,ERROR_MSG
4173: ,MSG_TOKENS)
4174: VALUES (G_WORKER_REQ_ID
4175: ,HEADER_INTERFACE_ROWID
4176: ,'OKS_COVERED_LEVELS_INTERFACE'
4177: ,COVERED_LEVEL_INTERFACE_ID
4178: ,'OKS_IMP_CLVL_INVALID_SDT_FBDT'
4179: ,NULL)
4180:

Line 4191: ,'OKS_COVERED_LEVELS_INTERFACE'

4187: ,ERROR_MSG
4188: ,MSG_TOKENS)
4189: VALUES (G_WORKER_REQ_ID
4190: ,HEADER_INTERFACE_ROWID
4191: ,'OKS_COVERED_LEVELS_INTERFACE'
4192: ,COVERED_LEVEL_INTERFACE_ID
4193: ,'OKS_IMP_CLVL_INVALID_RNMLCD'
4194: ,NULL)
4195: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN

Line 4205: ,'OKS_COVERED_LEVELS_INTERFACE'

4201: ,ERROR_MSG
4202: ,MSG_TOKENS)
4203: VALUES (G_WORKER_REQ_ID
4204: ,HEADER_INTERFACE_ROWID
4205: ,'OKS_COVERED_LEVELS_INTERFACE'
4206: ,COVERED_LEVEL_INTERFACE_ID
4207: ,'OKS_IMP_CLVL_INVALID_CNCLDT'
4208: ,NULL)
4209: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN

Line 4219: ,'OKS_COVERED_LEVELS_INTERFACE'

4215: ,ERROR_MSG
4216: ,MSG_TOKENS)
4217: VALUES (G_WORKER_REQ_ID
4218: ,HEADER_INTERFACE_ROWID
4219: ,'OKS_COVERED_LEVELS_INTERFACE'
4220: ,COVERED_LEVEL_INTERFACE_ID
4221: ,'OKS_IMP_CLVL_INVALID_CNCLRSN'
4222: ,NULL)
4223: WHEN (INVOICE_TEXT IS NULL ) THEN

Line 4233: ,'OKS_COVERED_LEVELS_INTERFACE'

4229: ,ERROR_MSG
4230: ,MSG_TOKENS)
4231: VALUES (G_WORKER_REQ_ID
4232: ,HEADER_INTERFACE_ROWID
4233: ,'OKS_COVERED_LEVELS_INTERFACE'
4234: ,COVERED_LEVEL_INTERFACE_ID
4235: ,'OKS_IMP_CLVL_INVALID_INVTXT'
4236: ,NULL)
4237: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <>'N')) THEN

Line 4247: ,'OKS_COVERED_LEVELS_INTERFACE'

4243: ,ERROR_MSG
4244: ,MSG_TOKENS)
4245: VALUES (G_WORKER_REQ_ID
4246: ,HEADER_INTERFACE_ROWID
4247: ,'OKS_COVERED_LEVELS_INTERFACE'
4248: ,COVERED_LEVEL_INTERFACE_ID
4249: ,'OKS_IMP_CLVL_INVALID_PRNTINV'
4250: ,NULL)
4251: WHEN (QUANTITY_COVERED IS NULL OR QUANTITY_COVERED <= 0 OR FLOOR(QUANTITY_COVERED) <> QUANTITY_COVERED ) THEN

Line 4261: ,'OKS_COVERED_LEVELS_INTERFACE'

4257: ,ERROR_MSG
4258: ,MSG_TOKENS)
4259: VALUES (G_WORKER_REQ_ID
4260: ,HEADER_INTERFACE_ROWID
4261: ,'OKS_COVERED_LEVELS_INTERFACE'
4262: ,COVERED_LEVEL_INTERFACE_ID
4263: ,'OKS_IMP_CLVL_INVALID_QUNTCOV'
4264: ,NULL)
4265: WHEN( QUOM_VALID = 'N' ) THEN

Line 4275: ,'OKS_COVERED_LEVELS_INTERFACE'

4271: ,ERROR_MSG
4272: ,MSG_TOKENS)
4273: VALUES (G_WORKER_REQ_ID
4274: ,HEADER_INTERFACE_ROWID
4275: ,'OKS_COVERED_LEVELS_INTERFACE'
4276: ,COVERED_LEVEL_INTERFACE_ID
4277: ,'OKS_IMP_CLVL_INVALID_QUOM'
4278: ,NULL)
4279: WHEN ((COVERED_INSTANCE_ID IS NOT NULL OR COVERED_ITEM_ID IS NOT NULL)

Line 4290: ,'OKS_COVERED_LEVELS_INTERFACE'

4286: ,ERROR_MSG
4287: ,MSG_TOKENS)
4288: VALUES (G_WORKER_REQ_ID
4289: ,HEADER_INTERFACE_ROWID
4290: ,'OKS_COVERED_LEVELS_INTERFACE'
4291: ,COVERED_LEVEL_INTERFACE_ID
4292: ,'OKS_IMP_CLVL_INVALID_PRUOM'
4293: ,NULL)
4294: WHEN ((COVERED_INSTANCE_ID IS NULL AND COVERED_ITEM_ID IS NULL) AND PRICE_UOM IS NOT NULL) THEN

Line 4304: ,'OKS_COVERED_LEVELS_INTERFACE'

4300: ,ERROR_MSG
4301: ,MSG_TOKENS)
4302: VALUES (G_WORKER_REQ_ID
4303: ,HEADER_INTERFACE_ROWID
4304: ,'OKS_COVERED_LEVELS_INTERFACE'
4305: ,COVERED_LEVEL_INTERFACE_ID
4306: ,'OKS_IMP_CLVL_INVALID_PRUOMNUL'
4307: ,NULL)
4308: WHEN (SUBTOTAL IS NULL OR SUBTOTAL <0 ) THEN

Line 4318: ,'OKS_COVERED_LEVELS_INTERFACE'

4314: ,ERROR_MSG
4315: ,MSG_TOKENS)
4316: VALUES (G_WORKER_REQ_ID
4317: ,HEADER_INTERFACE_ROWID
4318: ,'OKS_COVERED_LEVELS_INTERFACE'
4319: ,COVERED_LEVEL_INTERFACE_ID
4320: ,'OKS_IMP_CLVL_INVALID_SUBTOT'
4321: ,NULL)
4322: WHEN( TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 ) THEN

Line 4332: ,'OKS_COVERED_LEVELS_INTERFACE'

4328: ,ERROR_MSG
4329: ,MSG_TOKENS)
4330: VALUES (G_WORKER_REQ_ID
4331: ,HEADER_INTERFACE_ROWID
4332: ,'OKS_COVERED_LEVELS_INTERFACE'
4333: ,COVERED_LEVEL_INTERFACE_ID
4334: ,'OKS_IMP_CLVL_INVALID_TAXAMT'
4335: ,NULL)
4336:

Line 4347: ,'OKS_COVERED_LEVELS_INTERFACE'

4343: ,ERROR_MSG
4344: ,MSG_TOKENS)
4345: VALUES (G_WORKER_REQ_ID
4346: ,HEADER_INTERFACE_ROWID
4347: ,'OKS_COVERED_LEVELS_INTERFACE'
4348: ,COVERED_LEVEL_INTERFACE_ID
4349: ,'OKS_IMP_CLVL_INVALID_CLVLID'
4350: ,NULL)
4351: /* WHEN (FIRST_BILL_AMT_VALID ='N' ) THEN

Line 4361: ,'OKS_COVERED_LEVELS_INTERFACE'

4357: ,ERROR_MSG
4358: ,MSG_TOKENS)
4359: VALUES (G_WORKER_REQ_ID
4360: ,HEADER_INTERFACE_ROWID
4361: ,'OKS_COVERED_LEVELS_INTERFACE'
4362: ,COVERED_LEVEL_INTERFACE_ID
4363: ,'OKS_IMP_CLVL_INVALID_FBILAMT'
4364: ,NULL)
4365: WHEN (LAST_BILL_AMT_VALID ='N' ) THEN

Line 4375: ,'OKS_COVERED_LEVELS_INTERFACE'

4371: ,ERROR_MSG
4372: ,MSG_TOKENS)
4373: VALUES (G_WORKER_REQ_ID
4374: ,HEADER_INTERFACE_ROWID
4375: ,'OKS_COVERED_LEVELS_INTERFACE'
4376: ,COVERED_LEVEL_INTERFACE_ID
4377: ,'OKS_IMP_CLVL_INVALID_LBILAMT'
4378: ,NULL) */
4379:

Line 4518: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

4514: ELSE 'Y'
4515: END) LAST_BILL_AMT_VALID
4516: */
4517:
4518: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4519:
4520: ,OKS_COVERED_LEVELS_INTERFACE OCLIN
4521:
4522: ,OKS_INT_LINE_STG_TEMP OLSTG

Line 4520: ,OKS_COVERED_LEVELS_INTERFACE OCLIN

4516: */
4517:
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

Line 4595: SELECT count(1) INTO l_int_count FROM OKS_COVERED_LEVELS_INTERFACE OCLI

4591:
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;