DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_ORG_CARRIER_SITES

Line 1412: WSH_ORG_CARRIER_SITES ORG_SITES,

1408: CURSOR C_CARRIER_ADDRESS(C_ORGANIZATION_ID IN NUMBER,C_CARRIER_ID IN NUMBER,C_DELIVERY_ID IN NUMBER) IS
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

Line 1440: WSH_ORG_CARRIER_SITES ORG_SITES,

1436: CURSOR C_CARRIER_ADDRESS(C_CARRIER_ID IN NUMBER,C_DELIVERY_ID IN NUMBER) IS
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