DBA Data[Home] [Help]

APPS.WSH_AUTO_MANIFEST dependencies on HZ_PARTIES

Line 410: FROM wsh_carriers, hz_parties

406: ;
407:
408: CURSOR get_carrier_name(pc_carrier_id NUMBER) IS
409: SELECT party_name
410: FROM wsh_carriers, hz_parties
411: WHERE carrier_id =party_id (+)
412: AND carrier_id= pc_carrier_id;
413:
414: CURSOR get_customer_name(pc_customer_id NUMBER) IS

Line 416: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP

412: AND carrier_id= pc_carrier_id;
413:
414: CURSOR get_customer_name(pc_customer_id NUMBER) IS
415: SELECT HP.PARTY_NAME
416: FROM HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
417: WHERE HP.PARTY_ID = HCA.PARTY_ID
418: AND HP.PARTY_ID = pc_customer_id;
419:
420: /*Patchset I: Locations Project. Use ui_location_code from wsh_customer_locations_v */