DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on RCV_SHIPMENT_HEADERS

Line 941: rcv_shipment_headers rsh

937: ELSIF(p_supply_demand_type_id IN(26)) THEN --intransit
938: SELECT 'Y'
939: INTO x_valid_status
940: FROM rcv_shipment_lines rsl,
941: rcv_shipment_headers rsh
942: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
943: AND rsl.shipment_header_id = rsh.shipment_header_id
944: AND ( p_organization_id IS NULL
945: OR p_organization_id = rsl.to_organization_id)

Line 977: rcv_shipment_headers rsh

973: IF (p_supply_demand_type_id IN(25)) THEN --asn
974: SELECT 'Y'
975: INTO x_valid_status
976: FROM rcv_shipment_lines rsl,
977: rcv_shipment_headers rsh
978: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
979: AND rsl.shipment_header_id = rsh.shipment_header_id
980: AND rsl.shipment_line_id = p_supply_demand_line_detail
981: AND rsl.po_line_location_id = p_supply_demand_line_id