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.EGO_ITEM_BULKLOAD_PKG dependencies on FND_LOOKUP_VALUES

Line 1104: from FND_LOOKUP_VALUES

1100: ,'SUPPLIERSITE_PRIMARY','SUPPLIERSITE_STORE_STATUS','SUPPLIER_NUMBER')
1101: AND attribute_code NOT IN --Segregating Item Base Attributes using this clause
1102: (
1103: select LOOKUP_CODE CODE
1104: from FND_LOOKUP_VALUES
1105: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
1106: AND LANGUAGE = USERENV('LANG')
1107: AND ENABLED_FLAG = 'Y'
1108: )

Line 1966: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

1962: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
1963: l_dyn_sql := l_dyn_sql || '( ';
1964: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
1965: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_USER_ITEM_TYPE_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
1966: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
1967: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''ITEM_TYPE'' ';
1968: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
1969: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
1970: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2018: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2014: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2015: l_dyn_sql := l_dyn_sql || '( ';
2016: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2017: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_BOM_ITEM_TYPE_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2018: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2019: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''BOM_ITEM_TYPE'' ';
2020: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2021: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2022: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2116: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2112: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2113: l_dyn_sql := l_dyn_sql || '( ';
2114: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2115: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_ENG_ITEM_FLAG_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2116: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2117: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''EGO_YES_NO'' ';
2118: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2119: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2120: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2170: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2166: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2167: l_dyn_sql := l_dyn_sql || '( ';
2168: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2169: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_CONVERSIONS_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2170: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2171: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''MTL_CONVERSION_TYPE'' ';
2172: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2173: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2174: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2222: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2218: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2219: l_dyn_sql := l_dyn_sql || '( ';
2220: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2221: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_SECONDARY_DEF_IND_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2222: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2223: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_DEFAULTING_UOM_TYPE'' ';
2224: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2225: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2226: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2274: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2270: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2271: l_dyn_sql := l_dyn_sql || '( ';
2272: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2273: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_ONT_PRICING_QTY_SRC_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2274: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2275: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_PRICING_UOM_TYPE'' ';
2276: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2277: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2278: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2377: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

2373: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2374: l_dyn_sql := l_dyn_sql || '( ';
2375: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2376: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_TRACKING_QTY_IND_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2377: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2378: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_TRACKING_UOM_TYPE'' ';
2379: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2380: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2381: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 2510: l_dyn_sql := l_dyn_sql || ' , FND_LOOKUP_VALUES_VL LKUP ';

2506:
2507: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2508:
2509: IF (l_prod_col_name_tbl(i) IN ('STYLE_ITEM_FLAG', 'GDSN_OUTBOUND_ENABLED_FLAG' )) THEN
2510: l_dyn_sql := l_dyn_sql || ' , FND_LOOKUP_VALUES_VL LKUP ';
2511: END IF;
2512:
2513: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
2514: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';

Line 3326: from FND_LOOKUP_VALUES

3322: AND (
3323: attribute_code IN -- Segregating Item Revision Base Attributes using this clause
3324: (
3325: select LOOKUP_CODE CODE
3326: from FND_LOOKUP_VALUES
3327: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
3328: AND LANGUAGE = USERENV('LANG')
3329: AND ENABLED_FLAG = 'Y'
3330: and LOOKUP_CODE not in ('REVISION_CREATION_DATE', 'REVISION_CREATED_BY')

Line 3776: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

3772: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3773: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||G_REV_REASON_DB_COL||' = ';
3774: l_dyn_sql := l_dyn_sql || '( ';
3775: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
3776: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
3777: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE = ''EGO_ITEM_REVISION_REASON'' ';
3778: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE = Userenv(''LANG'') ';
3779: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING = EBI.'||l_intf_col_name_tbl(i);
3780: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 3790: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';

3786: l_dyn_sql := l_dyn_sql || ') ';
3787: l_dyn_sql := l_dyn_sql || ' WHERE EXISTS ';
3788: l_dyn_sql := l_dyn_sql || '( ';
3789: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
3790: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
3791: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE = ''EGO_ITEM_REVISION_REASON'' ';
3792: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE = Userenv(''LANG'') ';
3793: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING = EBI.'||l_intf_col_name_tbl(i);
3794: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';

Line 6218: from FND_LOOKUP_VALUES

6214: AND attribute_code NOT LIKE 'GTIN_%'
6215: AND attribute_code IN --Segregating Item Revision Base Attrs using this clause
6216: (
6217: select LOOKUP_CODE CODE
6218: from FND_LOOKUP_VALUES
6219: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
6220: AND LANGUAGE = USERENV('LANG')
6221: AND ENABLED_FLAG = 'Y'
6222: );

Line 7416: FROM FND_LOOKUP_VALUES_VL

7412: END LOOP; --FOR c_item_rev_attr_intf_rec
7413:
7414: SELECT MEANING
7415: INTO l_yes_meaning
7416: FROM FND_LOOKUP_VALUES_VL
7417: WHERE LOOKUP_TYPE = 'EGO_YES_NO'
7418: AND LOOKUP_CODE = 'Y';
7419:
7420: SELECT MEANING

Line 7422: FROM FND_LOOKUP_VALUES_VL

7418: AND LOOKUP_CODE = 'Y';
7419:
7420: SELECT MEANING
7421: INTO l_no_meaning
7422: FROM FND_LOOKUP_VALUES_VL
7423: WHERE LOOKUP_TYPE = 'EGO_YES_NO'
7424: AND LOOKUP_CODE = 'N';
7425:
7426: SELECT MEANING

Line 7428: FROM FND_LOOKUP_VALUES_VL

7424: AND LOOKUP_CODE = 'N';
7425:
7426: SELECT MEANING
7427: INTO l_active_meaning
7428: FROM FND_LOOKUP_VALUES_VL
7429: WHERE LOOKUP_TYPE = 'EGO_ASSOCIATION_STATUS'
7430: AND LOOKUP_CODE = '1';
7431:
7432: SELECT MEANING

Line 7434: FROM FND_LOOKUP_VALUES_VL

7430: AND LOOKUP_CODE = '1';
7431:
7432: SELECT MEANING
7433: INTO l_inactive_meaning
7434: FROM FND_LOOKUP_VALUES_VL
7435: WHERE LOOKUP_TYPE = 'EGO_ASSOCIATION_STATUS'
7436: AND LOOKUP_CODE = '2';
7437:
7438: ----------------------------------------------------------------------