APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on ZX_SCO_EXCEPTIONS

Line 44: FROM zx_sco_exceptions

40: p_tax_rate_code VARCHAR2,
41: p_tax_jurisdiction_id NUMBER
42: ) IS
43: SELECT tax_exception_id, exception_type_code, rate_modifier
44: FROM zx_sco_exceptions
45: WHERE product_id = p_inventory_item_id
46: -- AND inventory_org_id = p_inventory_organization_id
47: AND classification_type_code IS NULL
48: AND classification_code IS NULL

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

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

Line 109: FROM zx_sco_exceptions ex,

105: ) IS
106: SELECT ex.tax_exception_id,
107: ex.exception_type_code,
108: ex.rate_modifier
109: FROM zx_sco_exceptions ex,
110: mtl_categories_b_kfv mc,
111: mtl_category_sets_b mcs,
112: fnd_id_flex_structures_vl fifs,
113: zx_fc_types_b fc,

Line 148: FROM zx_sco_exceptions ex, zx_fc_types_b fct, zx_fc_types_reg_assoc fcreg, zx_fc_codes_b fcc

144: p_tax_rate_code VARCHAR2,
145: p_tax_jurisdiction_id NUMBER
146: ) IS
147: SELECT tax_exception_id, exception_type_code, rate_modifier
148: FROM zx_sco_exceptions ex, zx_fc_types_b fct, zx_fc_types_reg_assoc fcreg, zx_fc_codes_b fcc
149: WHERE ex.tax_regime_code = p_tax_regime_code
150: AND (ex.tax = p_tax or ex.tax is null)
151: AND (ex.tax_status_code = p_tax_status_code or ex.tax_status_code is null)
152: AND (ex.tax_rate_code = p_tax_rate_code or ex.tax_rate_code is null)