DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on HZ_PARTY_SITES

Line 18131: (SELECT p.party_name FROM hz_party_sites ps, hz_parties p WHERE p.party_id = ps.party_id AND ps.location_id = wdd.ship_to_location_id AND party_type = 'ORGANIZATION' and rownum=1) SHIP_TO_CUSTOMER,

18127: WDD.SHIP_METHOD_CODE SHIP_METHOD,
18128: WDD.SHIP_MODEL_COMPLETE_FLAG,
18129: WDD.SHIP_SET_ID,
18130: (select ui_location_code from wsh_locations where wsh_location_id=WDD.SHIP_TO_CONTACT_ID),
18131: (SELECT p.party_name FROM hz_party_sites ps, hz_parties p WHERE p.party_id = ps.party_id AND ps.location_id = wdd.ship_to_location_id AND party_type = 'ORGANIZATION' and rownum=1) SHIP_TO_CUSTOMER,
18132: WDD.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY,
18133: WDD.SHIPPING_INSTRUCTIONS,
18134: WDD.SRC_REQUESTED_QUANTITY,
18135: WDD.SRC_REQUESTED_QUANTITY_UOM,