DBA Data[Home] [Help]

APPS.JAI_INV_ITEMS_PKG dependencies on JAI_RGM_ITEM_ATTRIB_V

Line 36: FROM jai_rgm_item_attrib_v

32: /* Added by Brathod from bug# 4299606 */
33: CURSOR cur_get_item_attrib
34: IS
35: SELECT attribute_value , template_id , rgm_item_regns_id
36: FROM jai_rgm_item_attrib_v
37: WHERE attribute_code = p_attribute_code
38: AND inventory_item_id = p_inventory_item_id
39: AND organization_id = p_organization_id
40: AND regime_code = p_regime_code;

Line 517: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type

513: );
514:
515: cursor cur_get_itm_attribs
516: (
517: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type
518: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type
519: )
520: is
521: select attribute_code,

Line 518: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type

514:
515: cursor cur_get_itm_attribs
516: (
517: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type
518: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type
519: )
520: is
521: select attribute_code,
522: attribute_value,

Line 524: from jai_rgm_item_attrib_v

520: is
521: select attribute_code,
522: attribute_value,
523: last_updated_by
524: from jai_rgm_item_attrib_v
525: where organization_id = cpn_organization_id
526: and inventory_item_id = cpn_inventory_item_id
527: AND regime_code = jai_constants.excise_regime ;
528: