DBA Data[Home] [Help]

APPS.PO_AUTOSOURCE_SV dependencies on PO_AGENTS

Line 199: --we make an attempt to default it from the po_agents table

195: x_buyer_id := NULL;
196: x_item_buyer_id := NULL;
197: END;
198: --bug#3048965 if the buyer id in mtl_system_items table is null then
199: --we make an attempt to default it from the po_agents table
200: --if there is only one buyer defined for the category associated
201: --with the Purchasing category set of the concerned item.
202: IF(x_buyer_id is null)THEN
203: begin

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