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 1142: from FND_LOOKUP_VALUES

1138: ,'SUPPLIERSITE_PRIMARY','SUPPLIERSITE_STORE_STATUS','SUPPLIER_NUMBER')
1139: AND attribute_code NOT IN --Segregating Item Base Attributes using this clause
1140: (
1141: select LOOKUP_CODE CODE
1142: from FND_LOOKUP_VALUES
1143: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
1144: AND LANGUAGE = USERENV('LANG')
1145: AND ENABLED_FLAG = 'Y'
1146: )

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

2027: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2028: l_dyn_sql := l_dyn_sql || '( ';
2029: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2030: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_USER_ITEM_TYPE_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2031: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2032: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''ITEM_TYPE'' ';
2033: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2034: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2035: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2079: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2080: l_dyn_sql := l_dyn_sql || '( ';
2081: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2082: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_BOM_ITEM_TYPE_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2083: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2084: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''BOM_ITEM_TYPE'' ';
2085: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2086: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2087: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2177: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2178: l_dyn_sql := l_dyn_sql || '( ';
2179: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2180: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_ENG_ITEM_FLAG_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2181: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2182: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''EGO_YES_NO'' ';
2183: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2184: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2185: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2231: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2232: l_dyn_sql := l_dyn_sql || '( ';
2233: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2234: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_CONVERSIONS_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2235: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2236: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''MTL_CONVERSION_TYPE'' ';
2237: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2238: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2239: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2283: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2284: l_dyn_sql := l_dyn_sql || '( ';
2285: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2286: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_SECONDARY_DEF_IND_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2287: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2288: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_DEFAULTING_UOM_TYPE'' ';
2289: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2290: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2291: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2335: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2336: l_dyn_sql := l_dyn_sql || '( ';
2337: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2338: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_ONT_PRICING_QTY_SRC_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2339: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2340: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_PRICING_UOM_TYPE'' ';
2341: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2342: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2343: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2438: l_dyn_sql := l_dyn_sql || ' , MSII.PROCESS_FLAG )= ';
2439: l_dyn_sql := l_dyn_sql || '( ';
2440: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
2441: l_dyn_sql := l_dyn_sql || ' , DECODE(NVL(IT.LOOKUP_CODE, ''NULL''),''NULL'','||G_TRACKING_QTY_IND_ERR_STS||', ' || G_PROCESS_STATUS || ') ';
2442: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
2443: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE (+) = ''INV_TRACKING_UOM_TYPE'' ';
2444: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE (+) = Userenv(''LANG'') ';
2445: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING (+) = EBI.'||l_intf_col_name_tbl(i);
2446: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

2574:
2575: l_dyn_sql := l_dyn_sql || ' FROM EGO_BULKLOAD_INTF EBI ';
2576:
2577: IF (l_prod_col_name_tbl(i) IN ('STYLE_ITEM_FLAG', 'GDSN_OUTBOUND_ENABLED_FLAG' )) THEN
2578: l_dyn_sql := l_dyn_sql || ' , FND_LOOKUP_VALUES_VL LKUP ';
2579: END IF;
2580:
2581: l_dyn_sql := l_dyn_sql || ' WHERE EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
2582: l_dyn_sql := l_dyn_sql || ' AND EBI.TRANSACTION_ID = MSII.TRANSACTION_ID ';

Line 3411: from FND_LOOKUP_VALUES

3407: AND (
3408: attribute_code IN -- Segregating Item Revision Base Attributes using this clause
3409: (
3410: select LOOKUP_CODE CODE
3411: from FND_LOOKUP_VALUES
3412: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
3413: AND LANGUAGE = USERENV('LANG')
3414: AND ENABLED_FLAG = 'Y'
3415: and LOOKUP_CODE not in ('REVISION_CREATION_DATE', 'REVISION_CREATED_BY')

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

3857: l_dyn_sql := l_dyn_sql || 'UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI ';
3858: l_dyn_sql := l_dyn_sql || ' SET MIRI.'||G_REV_REASON_DB_COL||' = ';
3859: l_dyn_sql := l_dyn_sql || '( ';
3860: l_dyn_sql := l_dyn_sql || ' SELECT IT.LOOKUP_CODE ';
3861: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
3862: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE = ''EGO_ITEM_REVISION_REASON'' ';
3863: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE = Userenv(''LANG'') ';
3864: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING = EBI.'||l_intf_col_name_tbl(i);
3865: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

3871: l_dyn_sql := l_dyn_sql || ') ';
3872: l_dyn_sql := l_dyn_sql || ' WHERE EXISTS ';
3873: l_dyn_sql := l_dyn_sql || '( ';
3874: l_dyn_sql := l_dyn_sql || ' SELECT ''X'' ';
3875: l_dyn_sql := l_dyn_sql || ' FROM FND_LOOKUP_VALUES IT, EGO_BULKLOAD_INTF EBI ';
3876: l_dyn_sql := l_dyn_sql || ' WHERE IT.LOOKUP_TYPE = ''EGO_ITEM_REVISION_REASON'' ';
3877: l_dyn_sql := l_dyn_sql || ' AND IT.LANGUAGE = Userenv(''LANG'') ';
3878: l_dyn_sql := l_dyn_sql || ' AND IT.MEANING = EBI.'||l_intf_col_name_tbl(i);
3879: l_dyn_sql := l_dyn_sql || ' AND EBI.RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID_EXISTS';

Line 6371: from FND_LOOKUP_VALUES

6367: AND attribute_code NOT LIKE 'GTIN_%'
6368: AND attribute_code IN --Segregating Item Revision Base Attrs using this clause
6369: (
6370: select LOOKUP_CODE CODE
6371: from FND_LOOKUP_VALUES
6372: where LOOKUP_TYPE = 'EGO_ITEM_REV_HDR_ATTR_GRP'
6373: AND LANGUAGE = USERENV('LANG')
6374: AND ENABLED_FLAG = 'Y'
6375: );

Line 7569: FROM FND_LOOKUP_VALUES_VL

7565: END LOOP; --FOR c_item_rev_attr_intf_rec
7566:
7567: SELECT MEANING
7568: INTO l_yes_meaning
7569: FROM FND_LOOKUP_VALUES_VL
7570: WHERE LOOKUP_TYPE = 'EGO_YES_NO'
7571: AND LOOKUP_CODE = 'Y';
7572:
7573: SELECT MEANING

Line 7575: FROM FND_LOOKUP_VALUES_VL

7571: AND LOOKUP_CODE = 'Y';
7572:
7573: SELECT MEANING
7574: INTO l_no_meaning
7575: FROM FND_LOOKUP_VALUES_VL
7576: WHERE LOOKUP_TYPE = 'EGO_YES_NO'
7577: AND LOOKUP_CODE = 'N';
7578:
7579: SELECT MEANING

Line 7581: FROM FND_LOOKUP_VALUES_VL

7577: AND LOOKUP_CODE = 'N';
7578:
7579: SELECT MEANING
7580: INTO l_active_meaning
7581: FROM FND_LOOKUP_VALUES_VL
7582: WHERE LOOKUP_TYPE = 'EGO_ASSOCIATION_STATUS'
7583: AND LOOKUP_CODE = '1';
7584:
7585: SELECT MEANING

Line 7587: FROM FND_LOOKUP_VALUES_VL

7583: AND LOOKUP_CODE = '1';
7584:
7585: SELECT MEANING
7586: INTO l_inactive_meaning
7587: FROM FND_LOOKUP_VALUES_VL
7588: WHERE LOOKUP_TYPE = 'EGO_ASSOCIATION_STATUS'
7589: AND LOOKUP_CODE = '2';
7590:
7591: ----------------------------------------------------------------------