APPS.JL_ZZ_RECEIV_INTERFACE dependencies on MTL_ITEM_CATEGORIES

Line 1055: mtl_item_categories mic

1051: BEGIN
1052: SELECT fc.classification_code
1053: INTO l_fcc_code
1054: FROM zx_fc_product_fiscal_v fc,
1055: mtl_item_categories mic
1056: WHERE
1057: ((fc.country_code = l_country_code
1058: AND fc.country_code in ('AR', 'BR', 'CO'))
1059: or

Line 1090: mtl_item_categories mic

1086: BEGIN
1087: SELECT fc.classification_code
1088: INTO l_fcc_code
1089: FROM zx_fc_product_fiscal_v fc,
1090: mtl_item_categories mic
1091: WHERE
1092: ((fc.country_code = l_country_code
1093: AND fc.country_code in ('AR', 'BR', 'CO'))
1094: or

Line 1207: c_inventory_item_id MTL_ITEM_CATEGORIES.inventory_item_id%TYPE,

1203:
1204: -- bug#7827647
1205: CURSOR c_get_fsc
1206: (c_country_code ZX_FC_CODES_B.country_code%TYPE,
1207: c_inventory_item_id MTL_ITEM_CATEGORIES.inventory_item_id%TYPE,
1208: c_inventory_org_id MTL_ITEM_CATEGORIES.organization_id%TYPE,
1209: c_org_id JL_ZZ_AR_TX_FSC_CLS_ALL.org_id%TYPE
1210: )
1211: IS

Line 1208: c_inventory_org_id MTL_ITEM_CATEGORIES.organization_id%TYPE,

1204: -- bug#7827647
1205: CURSOR c_get_fsc
1206: (c_country_code ZX_FC_CODES_B.country_code%TYPE,
1207: c_inventory_item_id MTL_ITEM_CATEGORIES.inventory_item_id%TYPE,
1208: c_inventory_org_id MTL_ITEM_CATEGORIES.organization_id%TYPE,
1209: c_org_id JL_ZZ_AR_TX_FSC_CLS_ALL.org_id%TYPE
1210: )
1211: IS
1212: SELECT fc.classification_code

Line 1214: mtl_item_categories mic

1210: )
1211: IS
1212: SELECT fc.classification_code
1213: FROM zx_fc_product_fiscal_v fc,
1214: mtl_item_categories mic
1215: WHERE
1216: ((fc.country_code = c_country_code
1217: AND fc.country_code in ('AR', 'BR', 'CO'))
1218: or

Line 1368: mtl_item_categories mic

1364: BEGIN
1365: SELECT fc.classification_code
1366: INTO l_fcc_code
1367: FROM zx_fc_product_fiscal_v fc,
1368: mtl_item_categories mic
1369: WHERE
1370: ((fc.country_code = l_country_code
1371: AND fc.country_code in ('AR', 'BR', 'CO'))
1372: or

Line 1402: mtl_item_categories mic

1398: BEGIN
1399: SELECT fc.classification_code
1400: INTO l_fcc_code
1401: FROM zx_fc_product_fiscal_v fc,
1402: mtl_item_categories mic
1403: WHERE
1404: ((fc.country_code = l_country_code
1405: AND fc.country_code in ('AR', 'BR', 'CO'))
1406: or