545: SELECT
546: PS.LOCATION_ID
547: INTO BILL_TO_LOC_ID
548: FROM
549: HZ_PARTY_SITES PS,
550: HZ_CUST_ACCT_SITES_ALL CA,
551: HZ_CUST_SITE_USES_ALL SU,
552: OE_ORDER_LINES_ALL OLA
553: WHERE OLA.LINE_ID = CF_OE_LINE_ID
753: NVL(HP.PERSON_PRE_NAME_ADJUNCT
754: ,HP.PERSON_TITLE) TITLE
755: INTO BILL_TO_CUST_NAME,L_PERSON_TITLE
756: FROM
757: HZ_PARTY_SITES PS,
758: HZ_CUST_ACCT_SITES_ALL CA,
759: HZ_CUST_SITE_USES_ALL SU,
760: HZ_PARTIES HP,
761: OE_ORDER_LINES_ALL OLA
835: NVL(HP.PERSON_PRE_NAME_ADJUNCT
836: ,HP.PERSON_TITLE) TITLE
837: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
838: FROM
839: HZ_PARTY_SITES PS,
840: HZ_CUST_ACCT_SITES_ALL CA,
841: HZ_CUST_SITE_USES_ALL SU,
842: HZ_PARTIES HP
843: WHERE SU.SITE_USE_ID = F_SHIP_TO_SITE_USE_ID
917: SELECT
918: PS.LOCATION_ID
919: INTO BILL_TO_LOC_ID
920: FROM
921: HZ_PARTY_SITES PS,
922: HZ_CUST_ACCT_SITES_ALL CA,
923: HZ_CUST_SITE_USES_ALL SU,
924: OE_ORDER_LINES_ALL OLA
925: WHERE OLA.LINE_ID = F_OE_LINE_ID
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
1180: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1181: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
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
1208: AND HZ_SITES.PARTY_SITE_ID = ORG_SITES.CARRIER_SITE_ID
1209: AND HZ_SITES.PARTY_ID = C_CARRIER_ID