APPS.JAI_CMN_RG_OPM_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 49: JAI_CMN_VENDOR_SITES

45: excise_duty_Range,
46: excise_duty_division,
47: vendor_site_id
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

Line 128: JAI_CMN_VENDOR_SITES instead of ja_in_vendors. ja_in_vendors has been dropped

124: 1 17/10/2004 Aparajita.
125: Merge of OPM and Discrete with Obsoletion of PO logistics.
126:
127: Changed the definition of cursor C_vend_range_div to fetch the details from
128: JAI_CMN_VENDOR_SITES instead of ja_in_vendors. ja_in_vendors has been dropped
129: for the obsoletion of Obsoletion of PO logistics.
130:
131: Clean up was also done for the un necessary cusrosrs and code.
132:

Line 614: from JAI_CMN_VENDOR_SITES

610: where po_header_id = l_po_id;
611:
612: cursor C_vend_ran_div is
613: select excise_duty_range, excise_duty_division
614: from JAI_CMN_VENDOR_SITES
615: where vendor_id = l_shipvend_id;
616:
617: cursor C_Excise_Payable IS
618: select payable_excise

Line 661: JAI_CMN_VENDOR_SITES instead of ja_in_vendors. ja_in_vendors has been dropped

657: 2 17/10/2004 Aparajita.
658: Merge of OPM and Discrete with Obsoletion of PO logistics.
659:
660: Changed the definition of cursor C_vend_ran_div to fetch the details from
661: JAI_CMN_VENDOR_SITES instead of ja_in_vendors. ja_in_vendors has been dropped
662: for the obsoletion of Obsoletion of PO logistics.
663:
664: --------------------------------------------------------------------------------------------------------------------------*/
665: