DBA Data[Home] [Help]

APPS.JL_ZZ_RECEIV_INTERFACE dependencies on ZX_FC_PRODUCT_FISCAL_V

Line 1028: FROM zx_fc_product_fiscal_v fc,

1024: -- get default fiscal classification
1025: BEGIN
1026: SELECT fc.classification_code
1027: INTO l_fcc_code
1028: FROM zx_fc_product_fiscal_v fc,
1029: mtl_item_categories mic
1030: WHERE
1031: ((fc.country_code = l_country_code
1032: AND fc.country_code in ('AR', 'BR', 'CO'))

Line 1063: FROM zx_fc_product_fiscal_v fc,

1059:
1060: BEGIN
1061: SELECT fc.classification_code
1062: INTO l_fcc_code
1063: FROM zx_fc_product_fiscal_v fc,
1064: mtl_item_categories mic
1065: WHERE
1066: ((fc.country_code = l_country_code
1067: AND fc.country_code in ('AR', 'BR', 'CO'))

Line 1269: FROM zx_fc_product_fiscal_v fc,

1265: -- get default fiscal classification
1266: BEGIN
1267: SELECT fc.classification_code
1268: INTO l_fcc_code
1269: FROM zx_fc_product_fiscal_v fc,
1270: mtl_item_categories mic
1271: WHERE
1272: ((fc.country_code = l_country_code
1273: AND fc.country_code in ('AR', 'BR', 'CO'))

Line 1304: FROM zx_fc_product_fiscal_v fc,

1300:
1301: BEGIN
1302: SELECT fc.classification_code
1303: INTO l_fcc_code
1304: FROM zx_fc_product_fiscal_v fc,
1305: mtl_item_categories mic
1306: WHERE
1307: ((fc.country_code = l_country_code
1308: AND fc.country_code in ('AR', 'BR', 'CO'))