DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on MTL_CATEGORY_SETS_B

Line 67: FROM zx_sco_exceptions ex, mtl_categories_b_kfv mc, mtl_category_sets_b mcs,

63: p_inventory_item_id NUMBER,
64: p_inventory_organization_id NUMBER
65: ) IS
66: SELECT ex.tax_exception_id, ex.exception_type_code, ex.rate_modifier
67: FROM zx_sco_exceptions ex, mtl_categories_b_kfv mc, mtl_category_sets_b mcs,
68: fnd_id_flex_structures_vl fifs, mtl_item_categories mic,
69: zx_fc_types_b fc, zx_fc_types_reg_assoc fcreg
70: WHERE ex.product_id IS NULL
71: AND ex.tax_regime_code = p_tax_regime_code