[Home] [Help]
1133: --or all line/shipment cancellations.
1134:
1135: CURSOR cur_PO_records IS
1136:
1137: SELECT --standard POs with catalog items
1138:
1139: PH.SEGMENT1 PO_NUM, --header,detail
1140: 0 RELEASE_NUM, --NA for std PO
1141: PH.PO_HEADER_ID PO_HEADER_ID, --for get_total API
1185:
1186: WHERE
1187:
1188: PH.PO_HEADER_ID = PL.PO_HEADER_ID
1189: AND PH.TYPE_LOOKUP_CODE = 'STANDARD'
1190: AND PH.PCARD_ID IS NOT NULL --p-card used
1191: AND (PL.ITEM_ID = MSI.INVENTORY_ITEM_ID
1192: AND MSI.ORGANIZATION_ID = g_inv_org_id) --only item for that inv org
1193: AND PL.PO_LINE_ID = PLL.PO_LINE_ID
1209: AND PH.LAST_UPDATE_DATE >= g_from_date_time
1210: AND PH.LAST_UPDATE_DATE < g_to_date_time
1211: AND ac.card_reference_id = ibycc.instrid
1212:
1213: UNION ALL -- Standard POs with non-catalog items
1214:
1215: SELECT
1216: PH.SEGMENT1 PO_NUM, --header,detail
1217: 0 RELEASE_NUM, --NA for std PO
1259: iby_creditcard ibycc
1260:
1261: WHERE
1262: PH.PO_HEADER_ID = PL.PO_HEADER_ID
1263: AND PH.TYPE_LOOKUP_CODE = 'STANDARD'
1264: AND PH.PCARD_ID IS NOT NULL --p-card is used
1265: AND PL.ITEM_ID IS NULL --non-catalog item has no id
1266: AND PL.PO_LINE_ID = PLL.PO_LINE_ID
1267: AND PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1443: --cursor does not pick them up.
1444:
1445: CURSOR cur_canceled_POs IS
1446:
1447: SELECT --standard POs
1448:
1449: PH.SEGMENT1 PO_NUM, --header,detail
1450: 0 RELEASE_NUM, --NA for std PO
1451: PH.PO_HEADER_ID PO_HEADER_ID, --for get_total API
1479: FINANCIALS_SYSTEM_PARAMETERS FSP,
1480: iby_creditcard ibycc
1481:
1482: WHERE
1483: PH.TYPE_LOOKUP_CODE = 'STANDARD'
1484: AND PH.PCARD_ID IS NOT NULL --p-card is used
1485: AND FSP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
1486: AND PH.VENDOR_ID = PV.VENDOR_ID
1487: AND PV.VENDOR_ID = PVS.VENDOR_ID
1565: BEGIN
1566:
1567: l_progress := '000';
1568:
1569: --Insert standard POs and blanket releases with catalog or non-catalog items into por_feed_records
1570: IF cur_PO_records%ISOPEN THEN
1571: CLOSE cur_PO_records;
1572: END IF;
1573:
1693:
1694: l_progress := '020';
1695:
1696:
1697: --Insert canceled standard POs and blanket releases into por_feed_records
1698:
1699: IF cur_canceled_POs%ISOPEN THEN
1700: CLOSE cur_canceled_POs;
1701: END IF;