APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_LOOKUP_VALUES_VL

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