APPS.EGO_ITEM_BULKLOAD_PKG dependencies on FND_LOOKUP_VALUES_VL

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