存储过程4
PROC_STATUS,CRM_ORG_ID
FROM INT_ERP_PO_INFO
WHERE PROC_STATUS = 0
AND ERP_PO_STATUS = 0;
BEGIN
OPEN C_PO_INFO;
IF C_PO_INFO%ISOPEN THEN
LOOP
--query INT_ERP_PO_INFO
FETCH C_PO_INFO
INTO V_SOURCE_TYPE_CODE, V_PO_TYPE, V_GROUP_CODE, V_HEADER_DESCRIPTION, V_NOTE_TO_BUYER, V_NOTE_TO_RECEIVER, V_REFERENCE_NUM, V_SOURCE_ORGANIZATION_ID, V_DESTINATION_ORGANIZATION_ID, V_STORE_CODE, V_NEED_BY_DATE, V_SOURCE_CODE, V_SOURCE_HEADER_ID, V_CHANNEL_CODE, V_CUSTOMER_PO_NUMBER, V_ORDER_TYPE_ID, V_PRICE_LIST_ID, V_CHANNEL_LOCATION_BILL, V_CHANNEL_LOCATION_SHIP, V_DELIVERY_INSTRUCTIONS, V_ADDRESS1, V_ADDRESS2, V_ADDRESS3, V_ADDRESS4, V_CITY, V_COUNTY, V_STATE, V_PROVINCE, V_COUNTRY, V_POSTAL_CODE, V_GPS_COORDINATE_LATITUDE, V_GPS_COORDINATE_LONGITUDE, V_CONTACT_FIRST_NAME, V_CONTACT_LAST_NAME, V_CREATION_DATE, V_PROC_STATUS, V_CRM_ORG_ID;
EXIT WHEN C_PO_INFO%NOTFOUND;
--query the data is still can create PO or not
页:
[1]