[Home] [Help]
1122: -- will be based on supplier, supplier site, currency and OU. It
1123: -- will follow the order below:
1124: -- a. Matching BPA Header
1125: -- b. Matching CPA
1126: -- c. Matching Standard PO
1127: -- 3) If there is no CPA reference, and no source doc is found,
1128: -- then get the latest buyer created for the current business group.
1129: --
1130: -- This API should be called during the upgrade phase only.
1214: -- will be based on supplier, supplier site, currency and OU. It
1215: -- will follow the order below:
1216: -- 1. Matching BPA Header
1217: -- 2. Matching CPA
1218: -- 3. Matching Standard PO
1219: -- SQL Why : It will be used to populate the OUT parameters (to default the
1220: -- agent_id into the new GBPA)
1221: -- SQL Join: vendor_id, vendor_site_id, currency_code, org_id, type_lookup_code
1222: FORALL i IN 1 .. x_headers_rec.po_header_id.COUNT
1234: WHERE POH.vendor_id = x_headers_rec.vendor_id(i)
1235: AND POH.vendor_site_id = x_headers_rec.vendor_site_id(i)
1236: AND POH.currency_code = x_headers_rec.currency_code(i)
1237: AND POH.org_id = x_headers_rec.org_id(i)
1238: AND POH.type_lookup_code IN ('BLANKET', 'CONTRACT', 'STANDARD')
1239: AND EXISTS
1240: (SELECT 'Its a valid buyer'
1241: FROM PO_BUYERS_VAL_V VALID_BUYER
1242: WHERE VALID_BUYER.employee_id = POH.agent_id)
1243: ORDER BY
1244: DECODE(POH.type_lookup_code,
1245: 'BLANKET', 1,
1246: 'CONTRACT', 2,
1247: 'STANDARD', 3) ASC,
1248: POH.creation_date DESC)
1249: WHERE rownum = 1
1250: ) SUB_QUERY
1251: WHERE x_headers_rec.agent_id(i) IS NULL