DBA Data[Home] [Help]

APPS.INVPPROC dependencies on INV_SERIAL_NUMBER_PUB

Line 283: inv_serial_number_pub.delete_serial_tag_assignments(

279: END LOOP;
280: END IF;
281: -- serial_Tagging enh -- bug 9913552
282: FOR I IN serial_tag_del LOOP
283: inv_serial_number_pub.delete_serial_tag_assignments(
284: p_inventory_item_id=> i.inventory_item_id,
285: p_organization_id=>i.organization_id,
286: x_return_status=>x_ret_sts);
287: END LOOP;

Line 1132: , Decode (INV_SERIAL_NUMBER_PUB.is_serial_tagged(I.inventory_item_id,

1128: , I.TRADE_ITEM_DESCRIPTOR
1129: , I.STYLE_ITEM_FLAG
1130: , I.STYLE_ITEM_ID
1131: --serial_tagging enh -- bug 9913552
1132: , Decode (INV_SERIAL_NUMBER_PUB.is_serial_tagged(I.inventory_item_id,
1133: I.organization_id),2,'Y','N')
1134: FROM
1135: MTL_SYSTEM_ITEMS_INTERFACE I
1136: WHERE