[Home] [Help]
593: SELECT
594: PS.LOCATION_ID
595: INTO BILL_TO_LOC_ID
596: FROM
597: HZ_PARTY_SITES PS,
598: HZ_CUST_ACCT_SITES_ALL CA,
599: HZ_CUST_SITE_USES_ALL SU,
600: OE_ORDER_LINES_ALL OLA
601: WHERE OLA.LINE_ID = CF_OE_LINE_ID
633: IF BILL_TO_SITE_ID IS NOT NULL THEN
634: SELECT HPS.LOCATION_ID
635: INTO BILL_TO_LOC_ID
636: FROM PO_VENDOR_SITES_ALL PVS,
637: HZ_PARTY_SITES HPS
638: WHERE PVS.VENDOR_SITE_ID = BILL_TO_SITE_ID
639: AND PVS.PARTY_SITE_ID = HPS.PARTY_SITE_ID;
640: END IF;
641: END IF;
833: NVL(HP.PERSON_PRE_NAME_ADJUNCT
834: ,HP.PERSON_TITLE) TITLE
835: INTO BILL_TO_CUST_NAME,L_PERSON_TITLE
836: FROM
837: HZ_PARTY_SITES PS,
838: HZ_CUST_ACCT_SITES_ALL CA,
839: HZ_CUST_SITE_USES_ALL SU,
840: HZ_PARTIES HP,
841: OE_ORDER_LINES_ALL OLA
964: ,HP.PERSON_TITLE) TITLE
965: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
966: FROM
967: HZ_PARTY_SITE_USES PSU,
968: HZ_PARTY_SITES PS,
969: HZ_PARTIES HP
970: WHERE PSU.PARTY_SITE_USE_ID = SHP_TO_SITE_USE_ID
971: AND PSU.SITE_USE_TYPE = 'PURCHASING'
972: AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
978: NVL(HP.PERSON_PRE_NAME_ADJUNCT
979: ,HP.PERSON_TITLE) TITLE
980: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
981: FROM
982: HZ_PARTY_SITES PS,
983: HZ_CUST_ACCT_SITES_ALL CA,
984: HZ_CUST_SITE_USES_ALL SU,
985: HZ_PARTIES HP
986: WHERE SU.SITE_USE_ID = SHP_TO_SITE_USE_ID --RTV changes
1086: SELECT
1087: PS.LOCATION_ID
1088: INTO BILL_TO_LOC_ID
1089: FROM
1090: HZ_PARTY_SITES PS,
1091: HZ_CUST_ACCT_SITES_ALL CA,
1092: HZ_CUST_SITE_USES_ALL SU,
1093: OE_ORDER_LINES_ALL OLA
1094: WHERE OLA.LINE_ID = F_OE_LINE_ID
1126: IF BILL_TO_SITE_ID IS NOT NULL THEN
1127: SELECT HPS.LOCATION_ID
1128: INTO BILL_TO_LOC_ID
1129: FROM PO_VENDOR_SITES_ALL PVS,
1130: HZ_PARTY_SITES HPS
1131: WHERE PVS.VENDOR_SITE_ID = BILL_TO_SITE_ID
1132: AND PVS.PARTY_SITE_ID = HPS.PARTY_SITE_ID;
1133: END IF;
1134: END IF;
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
1418: AND HZ_SITES.PARTY_ID = C_CARRIER_ID
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
1446: AND HZ_SITES.PARTY_ID = C_CARRIER_ID