APPS.JL_ZZ_RECEIV_INTERFACE dependencies on ZX_FC_PRODUCT_FISCAL_V

Line 1054: FROM zx_fc_product_fiscal_v fc,

1050: -- get default fiscal classification
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'))

Line 1089: FROM zx_fc_product_fiscal_v fc,

1085:
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'))

Line 1213: FROM zx_fc_product_fiscal_v fc,

1209: c_org_id JL_ZZ_AR_TX_FSC_CLS_ALL.org_id%TYPE
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'))

Line 1367: FROM zx_fc_product_fiscal_v fc,

1363: /* Bug#7827647- replace with code below
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'))

Line 1401: FROM zx_fc_product_fiscal_v fc,

1397: IF l_fcc_code IS NULL AND l_country_code = 'CO' THEN
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'))