DBA Data[Home] [Help]

APPS.ZX_TCM_GET_EXCEPT_PKG dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 69: fnd_id_flex_structures_vl fifs, mtl_item_categories mic,

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
73: AND (ex.tax = p_tax or ex.tax is null)

Line 112: fnd_id_flex_structures_vl fifs,

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,
114: zx_fc_types_reg_assoc fcreg
115: WHERE ex.product_id IS NULL
116: AND ex.tax_regime_code = p_tax_regime_code