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 522: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type

518: );
519:
520: cursor cur_get_itm_attribs
521: (
522: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type
523: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type
524: )
525: is
526: select attribute_code,

Line 523: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type

519:
520: cursor cur_get_itm_attribs
521: (
522: cpn_organization_id jai_rgm_item_attrib_v.organization_id%type
523: ,cpn_inventory_item_id jai_rgm_item_attrib_v.inventory_item_id%type
524: )
525: is
526: select attribute_code,
527: attribute_value,

Line 529: from jai_rgm_item_attrib_v

525: is
526: select attribute_code,
527: attribute_value,
528: last_updated_by
529: from jai_rgm_item_attrib_v
530: where organization_id = cpn_organization_id
531: and inventory_item_id = cpn_inventory_item_id
532: AND regime_code = jai_constants.excise_regime ;
533: