APPS.JAI_CMN_RG_OPM_PKG dependencies on JAI_INV_ITM_SETUPS

Line 52: Cursor C_item_attributes(cpn_organization_id JAI_INV_ITM_SETUPS.organization_id%TYPE ,

48: From
49: JAI_CMN_VENDOR_SITES
50: Where vendor_id = p_vendor_id ;
51:
52: Cursor C_item_attributes(cpn_organization_id JAI_INV_ITM_SETUPS.organization_id%TYPE ,
53: cpn_inv_itm_id JAI_INV_ITM_SETUPS.inventory_item_id%type --p_item_id NUMBER
54: )
55: IS
56: Select

Line 53: cpn_inv_itm_id JAI_INV_ITM_SETUPS.inventory_item_id%type --p_item_id NUMBER

49: JAI_CMN_VENDOR_SITES
50: Where vendor_id = p_vendor_id ;
51:
52: Cursor C_item_attributes(cpn_organization_id JAI_INV_ITM_SETUPS.organization_id%TYPE ,
53: cpn_inv_itm_id JAI_INV_ITM_SETUPS.inventory_item_id%type --p_item_id NUMBER
54: )
55: IS
56: Select
57: item_class,

Line 60: jai_inv_itm_setups -- JAI_OPM_ITM_MASTERS --

56: Select
57: item_class,
58: nvl(modvat_flag, 'N')
59: From
60: jai_inv_itm_setups -- JAI_OPM_ITM_MASTERS --
61: Where organization_id = cpn_organization_id
62: AND inventory_item_id = cpn_inv_itm_id ;-- item_id = p_item_id;
63:
64: Cursor C_tran_date IS

Line 598: from JAI_INV_ITM_SETUPS --JAI_OPM_ITM_MASTERS

594: srno number;
595:
596: cursor C_itemclass is
597: select item_class
598: from JAI_INV_ITM_SETUPS --JAI_OPM_ITM_MASTERS
599: where organization_id = p_organization_id
600: AND inventory_item_id = p_inventory_item_id ;--item_id = p_item_id;
601:
602: cursor C_po_id is