DBA Data[Home] [Help]

APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on WSH_ORG_CARRIER_SITES

Line 1175: WSH_ORG_CARRIER_SITES ORG_SITES,

1171: CURSOR C_CARRIER_ADDRESS(C_ORGANIZATION_ID IN NUMBER,C_CARRIER_ID IN NUMBER,C_DELIVERY_ID IN NUMBER) IS
1172: SELECT
1173: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1174: FROM
1175: WSH_ORG_CARRIER_SITES ORG_SITES,
1176: WSH_NEW_DELIVERIES DEL,
1177: HZ_PARTY_SITES HZ_SITES,
1178: HZ_LOCATIONS LOC
1179: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID

Line 1203: WSH_ORG_CARRIER_SITES ORG_SITES,

1199: CURSOR C_CARRIER_ADDRESS(C_CARRIER_ID IN NUMBER,C_DELIVERY_ID IN NUMBER) IS
1200: SELECT
1201: LOC.ADDRESS1 || ', ' || LOC.ADDRESS2 || ', ' || LOC.ADDRESS3 || ', ' || LOC.ADDRESS4 || ', ' || LOC.CITY || ', ' || LOC.STATE || ', ' || LOC.COUNTRY || ', ' || LOC.POSTAL_CODE CARRIER_ADDR
1202: FROM
1203: WSH_ORG_CARRIER_SITES ORG_SITES,
1204: WSH_NEW_DELIVERIES DEL,
1205: HZ_PARTY_SITES HZ_SITES,
1206: HZ_LOCATIONS LOC
1207: WHERE ORG_SITES.ORGANIZATION_ID = DEL.ORGANIZATION_ID