[Home] [Help]
265: L_RESULT NUMBER;
266: L_RETURN_STATUS VARCHAR2(5);
267: L_MSG_COUNT NUMBER;
268: L_MSG_DATA VARCHAR2(3000);
269: L_CUSTOMER_ID WSH_NEW_DELIVERIES.CUSTOMER_ID%TYPE;
270: BEGIN
271: /*SRW.REFERENCE(C_DEL_CUSTOMER_ID)*/NULL;
272: /*SRW.REFERENCE(C_CUSTOMER_ID)*/NULL;
273: /*SRW.REFERENCE(C_SRC_LINE_ID)*/NULL;
1409: SELECT
1410: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1411: FROM
1412: WSH_ORG_CARRIER_SITES ORG_SITES,
1413: WSH_NEW_DELIVERIES DEL,
1414: HZ_PARTY_SITES HZ_SITES,
1415: HZ_LOCATIONS LOC
1416: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1417: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1437: SELECT
1438: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1439: FROM
1440: WSH_ORG_CARRIER_SITES ORG_SITES,
1441: WSH_NEW_DELIVERIES DEL,
1442: HZ_PARTY_SITES HZ_SITES,
1443: HZ_LOCATIONS LOC
1444: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID
1445: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1451: CURSOR C_DEL_CARRIER(C_DELIVERY_ID IN NUMBER) IS
1452: SELECT
1453: WND.CARRIER_ID DEL_CARRIER_ID
1454: FROM
1455: WSH_NEW_DELIVERIES WND
1456: WHERE WND.DELIVERY_ID = C_DELIVERY_ID;
1457: BEGIN
1458: IF (TRIP_CARRIER_ID IS NOT NULL) THEN
1459: FOR c_rec IN C_CARRIER_ADDRESS(c_carrier_id => trip_carrier_id,c_delivery_id => c_trip_delivery_id)
1645: IF p_delivery_id IS NOT NULL THEN
1646: SELECT hr.name
1647: INTO cp_warehouse_name
1648: FROM hr_organization_units hr,
1649: wsh_new_deliveries del
1650: WHERE del.organization_id = hr.organization_id
1651: AND del.delivery_id = p_delivery_id;
1652: ELSIF p_organization_id IS NOT NULL
1653: THEN