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 3831: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3827: END) COVERED_INSTANCE_ID
3828:
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)

Line 3844: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3840:
3841: ,COUNT(DISTINCT CITMSER.ROWID) OVER (PARTITION BY CLI.ROWID) CITMSER_COUNT
3842: ,MAX(CITMSER.INSTANCE_ID) OVER (PARTITION BY CLI.ROWID) CITMSER_ID -- ITEM INSTANCE ID Based on Serial number
3843:
3844: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3845: ,CSI_ITEM_INSTANCES CITMI
3846: ,CSI_ITEM_INSTANCES CITMN
3847: ,CSI_ITEM_INSTANCES CITMSER
3848: WHERE CLI.COVERED_INSTANCE_ID = CITMI.INSTANCE_ID (+)

Line 3889: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3885: END) COVERED_ITEM_ID
3886:
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)

Line 3900: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3896:
3897: ,COUNT(DISTINCT CMSIN.ROWID) OVER (PARTITION BY CLI.ROWID) CMSIN_COUNT
3898: ,MAX(CMSIN.INVENTORY_ITEM_ID) OVER (PARTITION BY CLI.ROWID) CMSIN_ID --COVERED ITEM ID Based on Name
3899:
3900: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3901: ,MTL_SYSTEM_ITEMS CMSII
3902: ,MTL_SYSTEM_ITEMS CMSIN
3903: WHERE CLI.COVERED_ITEM_ID = CMSII.INVENTORY_ITEM_ID (+) ----Modified for bug 13518018
3904: AND CLI.COVERED_ITEM_ORG_ID = CMSII.ORGANIZATION_ID(+)

Line 3947: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

3943: ELSE NULL
3944: END) COVERED_PARTY_ID
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)

Line 3962: FROM OKS_COVERED_LEVELS_INTERFACE CLI

3958:
3959: ,COUNT(DISTINCT HPIN.ROWID) OVER (PARTITION BY CLI.ROWID) HPIN_COUNT
3960: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3961:
3962: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3963: ,HZ_PARTIES HPI
3964: ,HZ_PARTIES HPINUM
3965: ,HZ_PARTIES HPIN
3966:

Line 4004: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

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

Line 4016: FROM OKS_COVERED_LEVELS_INTERFACE CLI

4012: ,COUNT(DISTINCT HCAN.ROWID) OVER (PARTITION BY CLI.ROWID) HCAN_COUNT
4013: ,MAX(HCAN.CUST_ACCOUNT_ID) OVER (PARTITION BY CLI.ROWID) HCAN_ID -- COVERED ACCOUNT ID Based on Number
4014:
4015:
4016: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4017: ,HZ_CUST_ACCOUNTS HCAI
4018: ,HZ_CUST_ACCOUNTS HCAN
4019:
4020: WHERE CLI.COVERED_ACCOUNT_ID = HCAI.CUST_ACCOUNT_ID (+)

Line 4057: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

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

Line 4069: FROM OKS_COVERED_LEVELS_INTERFACE CLI

4065:
4066: ,COUNT(DISTINCT CSITENUM.ROWID) OVER (PARTITION BY CLI.ROWID) CSITENUM_COUNT
4067: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4068:
4069: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4070: ,HZ_PARTY_SITES CSITEID
4071: ,HZ_PARTY_SITES CSITENUM
4072:
4073: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)

Line 4107: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

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

Line 4116: FROM OKS_COVERED_LEVELS_INTERFACE CLI

4112:
4113: ,COUNT(DISTINCT CSYSID.ROWID) OVER (PARTITION BY CLI.ROWID) CSYSID_COUNT
4114: ,MAX(CLI.COVERED_SYSTEM_ID) OVER (PARTITION BY CLI.ROWID) CSYSID_ID --COVERED SYSTEM ID Based on Id
4115:
4116: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4117: ,CSI_SYSTEMS_B CSYSID
4118:
4119: WHERE CLI.COVERED_SYSTEM_ID = CSYSID.SYSTEM_ID (+)) NAMEID_Q
4120:

Line 4158: ,'OKS_COVERED_LEVELS_INTERFACE'

4154: ,ERROR_MSG
4155: ,MSG_TOKENS)
4156: VALUES (G_WORKER_REQ_ID
4157: ,HEADER_INTERFACE_ROWID
4158: ,'OKS_COVERED_LEVELS_INTERFACE'
4159: ,COVERED_LEVEL_INTERFACE_ID
4160: ,'OKS_IMP_CLVL_INVALID_LINTID'
4161: ,NULL )
4162: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN

Line 4172: ,'OKS_COVERED_LEVELS_INTERFACE'

4168: ,ERROR_MSG
4169: ,MSG_TOKENS)
4170: VALUES (G_WORKER_REQ_ID
4171: ,HEADER_INTERFACE_ROWID
4172: ,'OKS_COVERED_LEVELS_INTERFACE'
4173: ,COVERED_LEVEL_INTERFACE_ID
4174: ,'OKS_IMP_CLVL_INVALID_LINNUM'
4175: ,NULL)
4176: WHEN ( STATUS_CODE IS NULL OR STATUS_CLVL_VALID ='N' OR STATUS_LINLVL_VALID='N') THEN

Line 4186: ,'OKS_COVERED_LEVELS_INTERFACE'

4182: ,ERROR_MSG
4183: ,MSG_TOKENS)
4184: VALUES (G_WORKER_REQ_ID
4185: ,HEADER_INTERFACE_ROWID
4186: ,'OKS_COVERED_LEVELS_INTERFACE'
4187: ,COVERED_LEVEL_INTERFACE_ID
4188: ,'OKS_IMP_CLVL_INVALID_STSCODE'
4189: ,NULL)
4190: WHEN (DATE_CLVL_VALID ='N' OR DATE_LINLVL_VALID='N') THEN

Line 4200: ,'OKS_COVERED_LEVELS_INTERFACE'

4196: ,ERROR_MSG
4197: ,MSG_TOKENS)
4198: VALUES (G_WORKER_REQ_ID
4199: ,HEADER_INTERFACE_ROWID
4200: ,'OKS_COVERED_LEVELS_INTERFACE'
4201: ,COVERED_LEVEL_INTERFACE_ID
4202: ,'OKS_IMP_CLVL_INVALID_DTRANGE'
4203: ,NULL)
4204: WHEN (DATE_CLVL_STS_VALID ='N' ) THEN

Line 4214: ,'OKS_COVERED_LEVELS_INTERFACE'

4210: ,ERROR_MSG
4211: ,MSG_TOKENS)
4212: VALUES (G_WORKER_REQ_ID
4213: ,HEADER_INTERFACE_ROWID
4214: ,'OKS_COVERED_LEVELS_INTERFACE'
4215: ,COVERED_LEVEL_INTERFACE_ID
4216: ,'OKS_IMP_CLVL_INVALID_STS_DT'
4217: ,NULL)
4218: WHEN (ST_DT_FST_BILL_YN ='N' ) THEN

Line 4228: ,'OKS_COVERED_LEVELS_INTERFACE'

4224: ,ERROR_MSG
4225: ,MSG_TOKENS)
4226: VALUES (G_WORKER_REQ_ID
4227: ,HEADER_INTERFACE_ROWID
4228: ,'OKS_COVERED_LEVELS_INTERFACE'
4229: ,COVERED_LEVEL_INTERFACE_ID
4230: ,'OKS_IMP_CLVL_INVALID_SDT_FBDT'
4231: ,NULL)
4232:

Line 4243: ,'OKS_COVERED_LEVELS_INTERFACE'

4239: ,ERROR_MSG
4240: ,MSG_TOKENS)
4241: VALUES (G_WORKER_REQ_ID
4242: ,HEADER_INTERFACE_ROWID
4243: ,'OKS_COVERED_LEVELS_INTERFACE'
4244: ,COVERED_LEVEL_INTERFACE_ID
4245: ,'OKS_IMP_CLVL_INVALID_RNMLCD'
4246: ,NULL)
4247: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN

Line 4257: ,'OKS_COVERED_LEVELS_INTERFACE'

4253: ,ERROR_MSG
4254: ,MSG_TOKENS)
4255: VALUES (G_WORKER_REQ_ID
4256: ,HEADER_INTERFACE_ROWID
4257: ,'OKS_COVERED_LEVELS_INTERFACE'
4258: ,COVERED_LEVEL_INTERFACE_ID
4259: ,'OKS_IMP_CLVL_INVALID_CNCLDT'
4260: ,NULL)
4261: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN

Line 4271: ,'OKS_COVERED_LEVELS_INTERFACE'

4267: ,ERROR_MSG
4268: ,MSG_TOKENS)
4269: VALUES (G_WORKER_REQ_ID
4270: ,HEADER_INTERFACE_ROWID
4271: ,'OKS_COVERED_LEVELS_INTERFACE'
4272: ,COVERED_LEVEL_INTERFACE_ID
4273: ,'OKS_IMP_CLVL_INVALID_CNCLRSN'
4274: ,NULL)
4275: WHEN (INVOICE_TEXT IS NULL ) THEN

Line 4285: ,'OKS_COVERED_LEVELS_INTERFACE'

4281: ,ERROR_MSG
4282: ,MSG_TOKENS)
4283: VALUES (G_WORKER_REQ_ID
4284: ,HEADER_INTERFACE_ROWID
4285: ,'OKS_COVERED_LEVELS_INTERFACE'
4286: ,COVERED_LEVEL_INTERFACE_ID
4287: ,'OKS_IMP_CLVL_INVALID_INVTXT'
4288: ,NULL)
4289: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <>'N')) THEN

Line 4299: ,'OKS_COVERED_LEVELS_INTERFACE'

4295: ,ERROR_MSG
4296: ,MSG_TOKENS)
4297: VALUES (G_WORKER_REQ_ID
4298: ,HEADER_INTERFACE_ROWID
4299: ,'OKS_COVERED_LEVELS_INTERFACE'
4300: ,COVERED_LEVEL_INTERFACE_ID
4301: ,'OKS_IMP_CLVL_INVALID_PRNTINV'
4302: ,NULL)
4303: WHEN (QUANTITY_COVERED IS NULL OR QUANTITY_COVERED <= 0 OR FLOOR(QUANTITY_COVERED) <> QUANTITY_COVERED ) THEN

Line 4313: ,'OKS_COVERED_LEVELS_INTERFACE'

4309: ,ERROR_MSG
4310: ,MSG_TOKENS)
4311: VALUES (G_WORKER_REQ_ID
4312: ,HEADER_INTERFACE_ROWID
4313: ,'OKS_COVERED_LEVELS_INTERFACE'
4314: ,COVERED_LEVEL_INTERFACE_ID
4315: ,'OKS_IMP_CLVL_INVALID_QUNTCOV'
4316: ,NULL)
4317: WHEN( QUOM_VALID = 'N' ) THEN

Line 4327: ,'OKS_COVERED_LEVELS_INTERFACE'

4323: ,ERROR_MSG
4324: ,MSG_TOKENS)
4325: VALUES (G_WORKER_REQ_ID
4326: ,HEADER_INTERFACE_ROWID
4327: ,'OKS_COVERED_LEVELS_INTERFACE'
4328: ,COVERED_LEVEL_INTERFACE_ID
4329: ,'OKS_IMP_CLVL_INVALID_QUOM'
4330: ,NULL)
4331: /*WHEN ((COVERED_INSTANCE_ID IS NOT NULL OR COVERED_ITEM_ID IS NOT NULL)

Line 4342: ,'OKS_COVERED_LEVELS_INTERFACE'

4338: ,ERROR_MSG
4339: ,MSG_TOKENS)
4340: VALUES (G_WORKER_REQ_ID
4341: ,HEADER_INTERFACE_ROWID
4342: ,'OKS_COVERED_LEVELS_INTERFACE'
4343: ,COVERED_LEVEL_INTERFACE_ID
4344: ,'OKS_IMP_CLVL_INVALID_PRUOM'
4345: ,NULL)*/ /*commented for bug:7804753*/
4346: WHEN ((COVERED_INSTANCE_ID IS NULL AND COVERED_ITEM_ID IS NULL) AND PRICE_UOM IS NOT NULL) THEN

Line 4356: ,'OKS_COVERED_LEVELS_INTERFACE'

4352: ,ERROR_MSG
4353: ,MSG_TOKENS)
4354: VALUES (G_WORKER_REQ_ID
4355: ,HEADER_INTERFACE_ROWID
4356: ,'OKS_COVERED_LEVELS_INTERFACE'
4357: ,COVERED_LEVEL_INTERFACE_ID
4358: ,'OKS_IMP_CLVL_INVALID_PRUOMNUL'
4359: ,NULL)
4360: WHEN (SUBTOTAL IS NULL OR SUBTOTAL <0 ) THEN

Line 4370: ,'OKS_COVERED_LEVELS_INTERFACE'

4366: ,ERROR_MSG
4367: ,MSG_TOKENS)
4368: VALUES (G_WORKER_REQ_ID
4369: ,HEADER_INTERFACE_ROWID
4370: ,'OKS_COVERED_LEVELS_INTERFACE'
4371: ,COVERED_LEVEL_INTERFACE_ID
4372: ,'OKS_IMP_CLVL_INVALID_SUBTOT'
4373: ,NULL)
4374: WHEN( TAX_AMOUNT IS NULL OR TAX_AMOUNT < 0 ) THEN

Line 4384: ,'OKS_COVERED_LEVELS_INTERFACE'

4380: ,ERROR_MSG
4381: ,MSG_TOKENS)
4382: VALUES (G_WORKER_REQ_ID
4383: ,HEADER_INTERFACE_ROWID
4384: ,'OKS_COVERED_LEVELS_INTERFACE'
4385: ,COVERED_LEVEL_INTERFACE_ID
4386: ,'OKS_IMP_CLVL_INVALID_TAXAMT'
4387: ,NULL)
4388:

Line 4399: ,'OKS_COVERED_LEVELS_INTERFACE'

4395: ,ERROR_MSG
4396: ,MSG_TOKENS)
4397: VALUES (G_WORKER_REQ_ID
4398: ,HEADER_INTERFACE_ROWID
4399: ,'OKS_COVERED_LEVELS_INTERFACE'
4400: ,COVERED_LEVEL_INTERFACE_ID
4401: ,'OKS_IMP_CLVL_INVALID_CLVLID'
4402: ,NULL)
4403: /* WHEN (FIRST_BILL_AMT_VALID ='N' ) THEN

Line 4413: ,'OKS_COVERED_LEVELS_INTERFACE'

4409: ,ERROR_MSG
4410: ,MSG_TOKENS)
4411: VALUES (G_WORKER_REQ_ID
4412: ,HEADER_INTERFACE_ROWID
4413: ,'OKS_COVERED_LEVELS_INTERFACE'
4414: ,COVERED_LEVEL_INTERFACE_ID
4415: ,'OKS_IMP_CLVL_INVALID_FBILAMT'
4416: ,NULL)
4417: WHEN (LAST_BILL_AMT_VALID ='N' ) THEN

Line 4427: ,'OKS_COVERED_LEVELS_INTERFACE'

4423: ,ERROR_MSG
4424: ,MSG_TOKENS)
4425: VALUES (G_WORKER_REQ_ID
4426: ,HEADER_INTERFACE_ROWID
4427: ,'OKS_COVERED_LEVELS_INTERFACE'
4428: ,COVERED_LEVEL_INTERFACE_ID
4429: ,'OKS_IMP_CLVL_INVALID_LBILAMT'
4430: ,NULL) */
4431: WHEN ( Nvl(COVERED_ITEM_ID,1) = -99 ) THEN /*skuchima bug16468231 */

Line 4441: ,'OKS_COVERED_LEVELS_INTERFACE'

4437: ,ERROR_MSG
4438: ,MSG_TOKENS)
4439: VALUES (G_WORKER_REQ_ID
4440: ,HEADER_INTERFACE_ROWID
4441: ,'OKS_COVERED_LEVELS_INTERFACE'
4442: ,COVERED_LEVEL_INTERFACE_ID
4443: ,'OKS_IMP_CLVL_INVALID_COVERED'
4444: ,NULL)
4445: WHEN ( Nvl(COVERED_PARTY_ID,1) = -99 ) THEN

Line 4455: ,'OKS_COVERED_LEVELS_INTERFACE'

4451: ,ERROR_MSG
4452: ,MSG_TOKENS)
4453: VALUES (G_WORKER_REQ_ID
4454: ,HEADER_INTERFACE_ROWID
4455: ,'OKS_COVERED_LEVELS_INTERFACE'
4456: ,COVERED_LEVEL_INTERFACE_ID
4457: ,'OKS_IMP_CLVL_INVALID_COVERED'
4458: ,NULL)
4459: WHEN ( Nvl(COVERED_ACCOUNT_ID,1) = -99 ) THEN

Line 4469: ,'OKS_COVERED_LEVELS_INTERFACE'

4465: ,ERROR_MSG
4466: ,MSG_TOKENS)
4467: VALUES (G_WORKER_REQ_ID
4468: ,HEADER_INTERFACE_ROWID
4469: ,'OKS_COVERED_LEVELS_INTERFACE'
4470: ,COVERED_LEVEL_INTERFACE_ID
4471: ,'OKS_IMP_CLVL_INVALID_COVERED'
4472: ,NULL)
4473: WHEN ( Nvl(COVERED_SITE_ID,1) = -99 ) THEN

Line 4483: ,'OKS_COVERED_LEVELS_INTERFACE'

4479: ,ERROR_MSG
4480: ,MSG_TOKENS)
4481: VALUES (G_WORKER_REQ_ID
4482: ,HEADER_INTERFACE_ROWID
4483: ,'OKS_COVERED_LEVELS_INTERFACE'
4484: ,COVERED_LEVEL_INTERFACE_ID
4485: ,'OKS_IMP_CLVL_INVALID_COVERED'
4486: ,NULL)
4487: WHEN ( Nvl(COVERED_SYSTEM_ID,1) = -99 ) THEN

Line 4497: ,'OKS_COVERED_LEVELS_INTERFACE'

4493: ,ERROR_MSG
4494: ,MSG_TOKENS)
4495: VALUES (G_WORKER_REQ_ID
4496: ,HEADER_INTERFACE_ROWID
4497: ,'OKS_COVERED_LEVELS_INTERFACE'
4498: ,COVERED_LEVEL_INTERFACE_ID
4499: ,'OKS_IMP_CLVL_INVALID_COVERED'
4500: ,NULL)
4501: SELECT OCLI.COVERED_LEVEL_INTERFACE_ID COVERED_LEVEL_INTERFACE_ID

Line 4644: FROM OKS_COVERED_LEVELS_INTERFACE OCLI

4640: ELSE 'Y'
4641: END) LAST_BILL_AMT_VALID
4642: */
4643:
4644: FROM OKS_COVERED_LEVELS_INTERFACE OCLI
4645:
4646: ,OKS_COVERED_LEVELS_INTERFACE OCLIN
4647:
4648: ,OKS_INT_LINE_STG_TEMP OLSTG

Line 4646: ,OKS_COVERED_LEVELS_INTERFACE OCLIN

4642: */
4643:
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

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

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