DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on MTL_ITEM_CATEGORIES

Line 205: from po_agents poa,mtl_item_categories mic

201: --with the Purchasing category set of the concerned item.
202: IF(x_buyer_id is null)THEN
203: begin
204: select poa.agent_id into x_buyer_id
205: from po_agents poa,mtl_item_categories mic
206: where mic.inventory_item_id=x_item_id
207: and mic.category_id=poa.category_id
208: and mic.organization_id=x_organization_id
209: and mic.category_set_id=(select category_set_id