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 800: ,FND_LOOKUPS FL

796: ,HZ_CUST_SITE_USES_ALL STSUI
797: ,FND_CURRENCIES FCUR
798: ,GL_DAILY_CONVERSION_TYPES GLCT
799: ,GL_DAILY_RATES GLDR
800: ,FND_LOOKUPS FL
801: ,RA_CUSTOMER_TRX_ALL CNI
802: ,FND_LOOKUPS PMC
803: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
804: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT

Line 802: ,FND_LOOKUPS PMC

798: ,GL_DAILY_CONVERSION_TYPES GLCT
799: ,GL_DAILY_RATES GLDR
800: ,FND_LOOKUPS FL
801: ,RA_CUSTOMER_TRX_ALL CNI
802: ,FND_LOOKUPS PMC
803: ,(SELECT distinct(HDI.HEADER_INTERFACE_ID) -- to avoid duplicate joins with tables when some names match with multiple records
804: ,COUNT(DISTINCT HPCUSTI.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_COUNT
805: ,MAX(HDI.CUSTOMER_PARTY_ID) OVER (PARTITION BY HDI.ROWID) HPCUSTI_ID -- CUSTOMER PARTY ID Based on Id
806: ,COUNT(DISTINCT HPCUSTN.ROWID) OVER (PARTITION BY HDI.ROWID) HPCUSTN_COUNT

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

1505: THEN 'N' ELSE 'Y' END) RENUPTO_VALID
1506: ,(CASE WHEN (HST.RENEW_UP_TO IS NOT NULL AND HST.RENEWAL_PROCESS <> 'EVN')
1507: THEN 'Y' ELSE 'N' END) RENUPTO_NULL_ERROR
1508: ,(CASE WHEN (HST.RENEWAL_PROCESS IN ('EVN', 'NSR')
1509: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1510: WHERE LOOKUP_TYPE = 'OKS_REN_MANUAL_APPROVAL'
1511: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1512: OR (HST.RENEWAL_PROCESS = 'ERN'
1513: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS

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

1509: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1510: WHERE LOOKUP_TYPE = 'OKS_REN_MANUAL_APPROVAL'
1511: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1512: OR (HST.RENEWAL_PROCESS = 'ERN'
1513: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1514: WHERE LOOKUP_TYPE = 'OKS_REN_ONLINE_APPROVAL'
1515: AND LOOKUP_CODE = HST.APPROVAL_REQUIRED))
1516: THEN 'N' ELSE 'Y' END) APRV_REQ_VALID
1517: ,(CASE WHEN (HST.APPROVAL_REQUIRED IS NOT NULL AND (HST.RENEWAL_PROCESS IS NULL OR HST.RENEWAL_PROCESS = 'DNR'))

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

1516: THEN 'N' ELSE 'Y' END) APRV_REQ_VALID
1517: ,(CASE WHEN (HST.APPROVAL_REQUIRED IS NOT NULL AND (HST.RENEWAL_PROCESS IS NULL OR HST.RENEWAL_PROCESS = 'DNR'))
1518: THEN 'Y' ELSE 'N' END) APRV_REQ_NULL_ERROR
1519: ,(CASE WHEN (HST.PRICING_METHOD IS NOT NULL AND (HST.RENEWAL_PROCESS IN ('EVN', 'NSR', 'ERN') OR HST.RENEWAL_PROCESS IS NULL)
1520: AND NOT EXISTS (SELECT 'X' FROM FND_LOOKUPS
1521: WHERE LOOKUP_TYPE = 'OKC_RENEWAL_PRICING_TYPE'
1522: AND LOOKUP_CODE = HST.PRICING_METHOD))
1523: THEN 'N' ELSE 'Y' END) PRM_VALID
1524: ,(CASE WHEN (HST.PRICING_METHOD IS NOT NULL AND HST.RENEWAL_PROCESS = 'DNR')

Line 1574: ,FND_LOOKUPS RENP

1570: FROM OKS_INT_HEADER_STG_TEMP HST
1571: ,OKC_SUBCLASSES_B CAT
1572: ,OKC_K_HEADERS_ALL_B HDR
1573: ,OKC_STATUSES_B STS
1574: ,FND_LOOKUPS RENP
1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1

Line 1575: ,FND_LOOKUPS RENPOREQ

1571: ,OKC_SUBCLASSES_B CAT
1572: ,OKC_K_HEADERS_ALL_B HDR
1573: ,OKC_STATUSES_B STS
1574: ,FND_LOOKUPS RENP
1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1
1579: ,FND_LOOKUPS CR2

Line 1578: ,FND_LOOKUPS CR1

1574: ,FND_LOOKUPS RENP
1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1
1579: ,FND_LOOKUPS CR2
1580: WHERE HST.CATEGORY = CAT.CODE (+)
1581: AND CAT.CLS_CODE(+) = 'SERVICE'
1582: AND HST.CONTRACT_NUMBER = HDR.CONTRACT_NUMBER (+)

Line 1579: ,FND_LOOKUPS CR2

1575: ,FND_LOOKUPS RENPOREQ
1576: ,OKC_TIME_CODE_UNITS_B RENGRPER
1577: ,OKC_TIME_CODE_UNITS_B RENESTPER
1578: ,FND_LOOKUPS CR1
1579: ,FND_LOOKUPS CR2
1580: WHERE HST.CATEGORY = CAT.CODE (+)
1581: AND CAT.CLS_CODE(+) = 'SERVICE'
1582: AND HST.CONTRACT_NUMBER = HDR.CONTRACT_NUMBER (+)
1583: AND nvl(HST.CONTRACT_NUMBER_MODIFIER , 'XgArBaGe!@#') = nvl(HDR.CONTRACT_NUMBER_MODIFIER (+), 'XgArBaGe!@#')

Line 1894: ,FND_LOOKUPS FOA

1890: ,HZ_CONTACT_POINTS QTP
1891: ,HZ_CONTACT_POINTS QTF
1892: ,HZ_CONTACT_POINTS QTE
1893: ,OKC_TIME_CODE_UNITS_B GRPER
1894: ,FND_LOOKUPS FOA
1895: ,OKC_QA_CHECK_LISTS_B QAC
1896: ,OKC_PROCESS_DEFS_B AP
1897: WHERE HST.OPERATING_UNIT_ID = QPS.ORG_ID (+)
1898: AND HST.QUOTE_TO_PARTY_SITE = QPS.CUST_ACCT_SITE_ID (+)

Line 2188: ,FND_LOOKUPS TEC

2184: AND COUNT(DISTINCT SRC.ROWID) OVER (PARTITION BY HST.ROWID) = 0
2185: THEN 'N' ELSE 'Y' END) SOURCE_V
2186: ,COUNT(DISTINCT HOI.ROWID) OVER (PARTITION BY HST.ROWID) HOI_COUNT
2187: FROM OKS_INT_HEADER_STG_TEMP HST
2188: ,FND_LOOKUPS TEC
2189: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2190: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2191: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2192: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN

Line 2193: ,FND_LOOKUPS BS

2189: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
2190: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
2191: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2192: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2193: ,FND_LOOKUPS BS
2194: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2195: ,FND_LOOKUPS SRC
2196: ,HR_ORGANIZATION_INFORMATION HOI
2197: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)

Line 2195: ,FND_LOOKUPS SRC

2191: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
2192: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2193: ,FND_LOOKUPS BS
2194: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2195: ,FND_LOOKUPS SRC
2196: ,HR_ORGANIZATION_INFORMATION HOI
2197: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)
2198: AND TEC.LOOKUP_TYPE (+) = 'ZX_EXEMPTION_CONTROL'
2199: AND HST.TAX_EXEMPTION_NUMBER = TEN.EXEMPT_CERTIFICATE_NUMBER (+)

Line 2684: ,FND_LOOKUPS FL

2680: ELSE NULL
2681: END) LAST_BILL_FROM_DATE
2682: FROM OKS_LINES_INTERFACE OLI
2683: ,OKS_INT_HEADER_STG_TEMP HDR
2684: ,FND_LOOKUPS FL
2685: ,RA_CUSTOMER_TRX_ALL CNI
2686: ,FND_LOOKUPS PMC
2687: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID
2688: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA

Line 2686: ,FND_LOOKUPS PMC

2682: FROM OKS_LINES_INTERFACE OLI
2683: ,OKS_INT_HEADER_STG_TEMP HDR
2684: ,FND_LOOKUPS FL
2685: ,RA_CUSTOMER_TRX_ALL CNI
2686: ,FND_LOOKUPS PMC
2687: ,(SELECT LSE.ROWID ROW_ID, LSE.LTY_CODE, LSE.ID ID
2688: FROM OKC_LINE_STYLES_B LSE, FND_APPLICATION FA
2689: WHERE LSE.APPLICATION_ID = FA.APPLICATION_ID
2690: AND FA.APPLICATION_SHORT_NAME = 'OKS') LS

Line 3263: ,FND_LOOKUPS CR1

3259: ,HR_ORGANIZATION_INFORMATION HOI
3260: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3261: ,OKC_STATUSES_B STS
3262: ,OKC_STATUSES_B HDRSTS
3263: ,FND_LOOKUPS CR1
3264: ,FND_LOOKUPS CR2
3265: ,FND_LOOKUPS TEC
3266: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC

Line 3264: ,FND_LOOKUPS CR2

3260: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3261: ,OKC_STATUSES_B STS
3262: ,OKC_STATUSES_B HDRSTS
3263: ,FND_LOOKUPS CR1
3264: ,FND_LOOKUPS CR2
3265: ,FND_LOOKUPS TEC
3266: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3268: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)

Line 3265: ,FND_LOOKUPS TEC

3261: ,OKC_STATUSES_B STS
3262: ,OKC_STATUSES_B HDRSTS
3263: ,FND_LOOKUPS CR1
3264: ,FND_LOOKUPS CR2
3265: ,FND_LOOKUPS TEC
3266: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3268: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3269: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN

Line 3270: ,FND_LOOKUPS RTC

3266: ,(SELECT EX.ROWID ROW_ID, EX.EXEMPT_CERTIFICATE_NUMBER, EX.EXEMPT_REASON_CODE
3267: FROM ZX_EXEMPTIONS EX, AR_LOOKUPS ERC
3268: WHERE EX.EXEMPT_REASON_CODE = ERC.LOOKUP_CODE (+)
3269: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
3270: ,FND_LOOKUPS RTC
3271: ,OKS_SUBSCR_HEADER_B TANGIBLE
3272: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3273: AND LST.ITEM_ORGANIZATION_ID = HOI.ORGANIZATION_ID (+)
3274: AND HOI.ORG_INFORMATION_CONTEXT (+) = 'CLASS'

Line 3692: ,FND_LOOKUPS STMI

3688: ,OKC_TIME_CODE_UNITS_B BIP
3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP
3692: ,FND_LOOKUPS STMI
3693: ,FND_LOOKUPS UTM
3694: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3695: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)
3696: AND LST.QUANTITY_UOM = SUOM.UOM_CODE (+)

Line 3693: ,FND_LOOKUPS UTM

3689: ,MTL_UNITS_OF_MEASURE SUOM
3690: ,OKC_TIME_CODE_UNITS_B PUOM
3691: ,OKC_TIME_CODE_UNITS_B USGP
3692: ,FND_LOOKUPS STMI
3693: ,FND_LOOKUPS UTM
3694: WHERE LST.HEADER_INTERFACE_ID = HDR.HEADER_INTERFACE_ID
3695: AND LST.BILLING_INTERVAL_PERIOD = BIP.UOM_CODE (+)
3696: AND LST.QUANTITY_UOM = SUOM.UOM_CODE (+)
3697: AND LST.PRICE_UOM = PUOM.UOM_CODE (+)

Line 4526: ,FND_LOOKUPS CR1

4522: ,OKS_INT_LINE_STG_TEMP OLSTG
4523:
4524: ,OKC_STATUSES_B STS
4525:
4526: ,FND_LOOKUPS CR1
4527:
4528: ,FND_LOOKUPS CR2
4529:
4530: ,OKC_TIME_CODE_UNITS_V PRUOM

Line 4528: ,FND_LOOKUPS CR2

4524: ,OKC_STATUSES_B STS
4525:
4526: ,FND_LOOKUPS CR1
4527:
4528: ,FND_LOOKUPS CR2
4529:
4530: ,OKC_TIME_CODE_UNITS_V PRUOM
4531:
4532: ,OKX_UNITS_OF_MEASURE_V QUOM

Line 4534: ,FND_LOOKUPS RNWLC

4530: ,OKC_TIME_CODE_UNITS_V PRUOM
4531:
4532: ,OKX_UNITS_OF_MEASURE_V QUOM
4533:
4534: ,FND_LOOKUPS RNWLC
4535:
4536: ,OKS_COVERED_INSTANCE_STG_TEMP OKSINST_STG
4537:
4538: ,OKS_COVERED_ITEM_STG_TEMP OKSITM_STG

Line 5118: ,FND_LOOKUPS ESTMTHD

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

Line 5120: ,FND_LOOKUPS CR1

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
5122: ,CSI_COUNTERS_B CSI_CNTR
5123:
5124: WHERE OUSGCNTR.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID

Line 5121: ,FND_LOOKUPS CR2

5117: ,OKS_INT_LINE_STG_TEMP OLSTG
5118: ,FND_LOOKUPS ESTMTHD
5119: ,OKC_STATUSES_B STS
5120: ,FND_LOOKUPS CR1
5121: ,FND_LOOKUPS CR2
5122: ,CSI_COUNTERS_B CSI_CNTR
5123:
5124: WHERE OUSGCNTR.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
5125: AND OUSGCNTR.ESTIMATION_METHOD = ESTMTHD.LOOKUP_CODE(+)

Line 5501: ,FND_LOOKUPS NTSTATUS

5497: END) ENTERED_DT_VALID
5498:
5499: FROM OKS_NOTES_INTERFACE ONI
5500: ,OKS_INT_HEADER_STG_TEMP OHSTG
5501: ,FND_LOOKUPS NTSTATUS
5502: ,FND_LOOKUPS NTTYPE
5503: ,FND_USER USR
5504:
5505: WHERE ONI.HEADER_INTERFACE_ID = OHSTG.HEADER_INTERFACE_ID

Line 5502: ,FND_LOOKUPS NTTYPE

5498:
5499: FROM OKS_NOTES_INTERFACE ONI
5500: ,OKS_INT_HEADER_STG_TEMP OHSTG
5501: ,FND_LOOKUPS NTSTATUS
5502: ,FND_LOOKUPS NTTYPE
5503: ,FND_USER USR
5504:
5505: WHERE ONI.HEADER_INTERFACE_ID = OHSTG.HEADER_INTERFACE_ID
5506: AND ONI.LINE_INTERFACE_ID IS NULL

Line 5614: ,FND_LOOKUPS NTSTATUS

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

Line 5615: ,FND_LOOKUPS NTTYPE

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