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 FND_LOOKUPS

Line 818: ,FND_LOOKUPS FL

814: ,HZ_CUST_SITE_USES_ALL STSUI
815: ,FND_CURRENCIES FCUR
816: ,GL_DAILY_CONVERSION_TYPES GLCT
817: ,GL_DAILY_RATES GLDR
818: ,FND_LOOKUPS FL
819: ,RA_CUSTOMER_TRX_ALL CNI
820: ,FND_LOOKUPS PMC
821: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
822: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT

Line 820: ,FND_LOOKUPS PMC

816: ,GL_DAILY_CONVERSION_TYPES GLCT
817: ,GL_DAILY_RATES GLDR
818: ,FND_LOOKUPS FL
819: ,RA_CUSTOMER_TRX_ALL CNI
820: ,FND_LOOKUPS PMC
821: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
822: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT
823: ,MAX(HDI.CUSTOMER_PARTY_ID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_ID -- CUSTOMER PARTY ID Based on Id
824: ,COUNT(DISTINCT HPCUSTN.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTN_COUNT

Line 1539: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS

1535: THEN 'N' ELSE 'Y' END) RENUPTO_VALID
1536: ,(CASE WHEN (HST.RENEW_UP_TO IS NOT NULL AND HST.RENEWAL_PROCESS <> 'EVN')
1537: THEN 'Y' ELSE 'N' END) RENUPTO_NULL_ERROR
1538: ,(CASE WHEN (HST.RENEWAL_PROCESS IN ('EVN', 'NSR')
1539: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1540: WHERE LOOKUP_TYPE = 'OKS_REN_MANUAL_APPROVAL'
1541: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1542: OR (HST.RENEWAL_PROCESS = 'ERN'
1543: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS

Line 1543: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS

1539: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1540: WHERE LOOKUP_TYPE = 'OKS_REN_MANUAL_APPROVAL'
1541: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1542: OR (HST.RENEWAL_PROCESS = 'ERN'
1543: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1544: WHERE LOOKUP_TYPE = 'OKS_REN_ONLINE_APPROVAL'
1545: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1546: THEN 'N' ELSE 'Y' END) APRV_REQ_VALID
1547: ,(CASE WHEN (HST.APPROVAL_REQUIRED IS NOT NULL AND (HST.RENEWAL_PROCESS IS NULL OR HST.RENEWAL_PROCESS = 'DNR'))

Line 1550: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS

1546: THEN 'N' ELSE 'Y' END) APRV_REQ_VALID
1547: ,(CASE WHEN (HST.APPROVAL_REQUIRED IS NOT NULL AND (HST.RENEWAL_PROCESS IS NULL OR HST.RENEWAL_PROCESS = 'DNR'))
1548: THEN 'Y' ELSE 'N' END) APRV_REQ_NULL_ERROR
1549: ,(CASE WHEN (HST.PRICING_METHOD IS NOT NULL AND (HST.RENEWAL_PROCESS IN ('EVN', 'NSR', 'ERN') OR HST.RENEWAL_PROCESS IS NULL)
1550: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1551: WHERE LOOKUP_TYPE = 'OKC_RENEWAL_PRICING_TYPE'
1552: AND LOOKUP_CODE = HST.PRICING_METHOD))
1553: THEN 'N' ELSE 'Y' END) PRM_VALID
1554: ,(CASE WHEN (HST.PRICING_METHOD IS NOT NULL AND HST.RENEWAL_PROCESS = 'DNR')

Line 1604: ,FND_LOOKUPS RENP

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
1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1

Line 1605: ,FND_LOOKUPS RENPOREQ

1601: ,OKC_SUBCLASSES_B CAT
1602: ,OKC_K_HEADERS_ALL_B HDR
1603: ,OKC_STATUSES_B STS
1604: ,FND_LOOKUPS RENP
1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1
1609: ,FND_LOOKUPS CR2

Line 1608: ,FND_LOOKUPS CR1

1604: ,FND_LOOKUPS RENP
1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1
1609: ,FND_LOOKUPS CR2
1610: WHERE HST.CATEGORY = CAT.CODE (+)
1611: AND CAT.CLS_CODE(+) = 'SERVICE'
1612: AND HST.CONTRACT_NUMBER = HDR.CONTRACT_NUMBER (+)

Line 1609: ,FND_LOOKUPS CR2

1605: ,FND_LOOKUPS RENPOREQ
1606: ,OKC_TIME_CODE_UNITS_B RENGRPER
1607: ,OKC_TIME_CODE_UNITS_B RENESTPER
1608: ,FND_LOOKUPS CR1
1609: ,FND_LOOKUPS CR2
1610: WHERE HST.CATEGORY = CAT.CODE (+)
1611: AND CAT.CLS_CODE(+) = 'SERVICE'
1612: AND HST.CONTRACT_NUMBER = HDR.CONTRACT_NUMBER (+)
1613: AND nvl(HST.CONTRACT_NUMBER_MODIFIER , 'XgArBaGe!@#') = nvl(HDR.CONTRACT_NUMBER_MODIFIER (+), 'XgArBaGe!@#')

Line 1924: ,FND_LOOKUPS FOA

1920: ,HZ_CONTACT_POINTS QTP
1921: ,HZ_CONTACT_POINTS QTF
1922: ,HZ_CONTACT_POINTS QTE
1923: ,OKC_TIME_CODE_UNITS_B GRPER
1924: ,FND_LOOKUPS FOA
1925: ,OKC_QA_CHECK_LISTS_B QAC
1926: ,OKC_PROCESS_DEFS_B AP
1927: WHERE HST.OPERATING_UNIT_ID = QPS.ORG_ID (+)
1928: AND HST.QUOTE_TO_PARTY_SITE = QPS.CUST_ACCT_SITE_ID (+)

Line 2218: ,FND_LOOKUPS TEC

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 (+)
2222: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN

Line 2223: ,FND_LOOKUPS BS

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 (+)
2222: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2223: ,FND_LOOKUPS BS
2224: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2225: ,FND_LOOKUPS SRC
2226: ,HR_ORGANIZATION_INFORMATION HOI
2227: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)

Line 2225: ,FND_LOOKUPS SRC

2221: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2222: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2223: ,FND_LOOKUPS BS
2224: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2225: ,FND_LOOKUPS SRC
2226: ,HR_ORGANIZATION_INFORMATION HOI
2227: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)
2228: AND TEC.LOOKUP_TYPE (+) = 'ZX_EXEMPTION_CONTROL'
2229: AND HST.TAX_EXEMPTION_NUMBER = TEN.EXEMPT_CERTIFICATE_NUMBER (+)

Line 2726: ,FND_LOOKUPS FL

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
2730: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA

Line 2728: ,FND_LOOKUPS PMC

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
2730: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA
2731: WHERE LSE.APPLICATION_ID = FA.APPLICATION_ID
2732: AND FA.APPLICATION_SHORT_NAME = 'OKS') LS

Line 3315: ,FND_LOOKUPS CR1

3311: ,HR_ORGANIZATION_INFORMATION HOI
3312: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3313: ,OKC_STATUSES_B STS
3314: ,OKC_STATUSES_B HDRSTS
3315: ,FND_LOOKUPS CR1
3316: ,FND_LOOKUPS CR2
3317: ,FND_LOOKUPS TEC
3318: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

Line 3316: ,FND_LOOKUPS CR2

3312: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3313: ,OKC_STATUSES_B STS
3314: ,OKC_STATUSES_B HDRSTS
3315: ,FND_LOOKUPS CR1
3316: ,FND_LOOKUPS CR2
3317: ,FND_LOOKUPS TEC
3318: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3320: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)

Line 3317: ,FND_LOOKUPS TEC

3313: ,OKC_STATUSES_B STS
3314: ,OKC_STATUSES_B HDRSTS
3315: ,FND_LOOKUPS CR1
3316: ,FND_LOOKUPS CR2
3317: ,FND_LOOKUPS TEC
3318: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3320: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3321: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN

Line 3322: ,FND_LOOKUPS RTC

3318: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3319: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3320: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3321: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
3322: ,FND_LOOKUPS RTC
3323: ,OKS_SUBSCR_HEADER_B TANGIBLE
3324: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3325: AND LST.ITEM_ORGANIZATION_ID = HOI.ORGANIZATION_ID (+)
3326: AND HOI.ORG_INFORMATION_CONTEXT (+) = 'CLASS'

Line 3744: ,FND_LOOKUPS STMI

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
3744: ,FND_LOOKUPS STMI
3745: ,FND_LOOKUPS UTM
3746: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3747: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)
3748: AND LST.QUANTITY_UOM = SUOM.UOM_CODE (+)

Line 3745: ,FND_LOOKUPS UTM

3741: ,MTL_UNITS_OF_MEASURE SUOM
3742: ,OKC_TIME_CODE_UNITS_B PUOM
3743: ,OKC_TIME_CODE_UNITS_B USGP
3744: ,FND_LOOKUPS STMI
3745: ,FND_LOOKUPS UTM
3746: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3747: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)
3748: AND LST.QUANTITY_UOM = SUOM.UOM_CODE (+)
3749: AND LST.PRICE_UOM = PUOM.UOM_CODE (+)

Line 4652: ,FND_LOOKUPS CR1

4648: ,OKS_INT_LINE_STG_TEMP OLSTG
4649:
4650: ,OKC_STATUSES_B STS
4651:
4652: ,FND_LOOKUPS CR1
4653:
4654: ,FND_LOOKUPS CR2
4655:
4656: ,OKC_TIME_CODE_UNITS_V PRUOM

Line 4654: ,FND_LOOKUPS CR2

4650: ,OKC_STATUSES_B STS
4651:
4652: ,FND_LOOKUPS CR1
4653:
4654: ,FND_LOOKUPS CR2
4655:
4656: ,OKC_TIME_CODE_UNITS_V PRUOM
4657:
4658: ,OKX_UNITS_OF_MEASURE_V QUOM

Line 4660: ,FND_LOOKUPS RNWLC

4656: ,OKC_TIME_CODE_UNITS_V PRUOM
4657:
4658: ,OKX_UNITS_OF_MEASURE_V QUOM
4659:
4660: ,FND_LOOKUPS RNWLC
4661:
4662: ,OKS_COVERED_INSTANCE_STG_TEMP OKSINST_STG
4663:
4664: ,OKS_COVERED_ITEM_STG_TEMP OKSITM_STG

Line 5244: ,FND_LOOKUPS ESTMTHD

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
5248: ,CSI_COUNTERS_B CSI_CNTR

Line 5246: ,FND_LOOKUPS CR1

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
5248: ,CSI_COUNTERS_B CSI_CNTR
5249:
5250: WHERE OUSGCNTR.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 5247: ,FND_LOOKUPS CR2

5243: ,OKS_INT_LINE_STG_TEMP OLSTG
5244: ,FND_LOOKUPS ESTMTHD
5245: ,OKC_STATUSES_B STS
5246: ,FND_LOOKUPS CR1
5247: ,FND_LOOKUPS CR2
5248: ,CSI_COUNTERS_B CSI_CNTR
5249:
5250: WHERE OUSGCNTR.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
5251: AND OUSGCNTR.ESTIMATION_METHOD = ESTMTHD.LOOKUP_CODE(+)

Line 5645: ,FND_LOOKUPS NTSTATUS

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:
5649: WHERE ONI.HEADER_INTERFACE_ID = OHSTG.HEADER_INTERFACE_ID

Line 5646: ,FND_LOOKUPS NTTYPE

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:
5649: WHERE ONI.HEADER_INTERFACE_ID = OHSTG.HEADER_INTERFACE_ID
5650: AND ONI.LINE_INTERFACE_ID IS NULL

Line 5758: ,FND_LOOKUPS NTSTATUS

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:
5762: WHERE ONI.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 5759: ,FND_LOOKUPS NTTYPE

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:
5762: WHERE ONI.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
5763: AND ONI.NOTE_STATUS =NTSTATUS.LOOKUP_CODE (+)