DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on RCV_SHIPMENT_HEADERS

Line 1035: rcv_shipment_headers rsh

1031: ELSIF(p_supply_demand_type_id IN(26)) THEN --intransit
1032: SELECT 'Y'
1033: INTO x_valid_status
1034: FROM rcv_shipment_lines rsl,
1035: rcv_shipment_headers rsh
1036: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
1037: AND rsl.shipment_header_id = rsh.shipment_header_id
1038: AND ( p_organization_id IS NULL
1039: OR p_organization_id = rsl.to_organization_id)

Line 1051: rcv_shipment_headers rsh

1047: IF (p_supply_demand_type_id IN(25)) THEN --asn
1048: SELECT 'Y'
1049: INTO x_valid_status
1050: FROM rcv_shipment_lines rsl,
1051: rcv_shipment_headers rsh
1052: WHERE shipment_line_status_code IN('EXPECTED', 'PARTIALLY RECEIVED')
1053: AND rsl.shipment_header_id = rsh.shipment_header_id
1054: AND rsl.shipment_line_id = p_supply_demand_line_detail
1055: AND rsl.po_line_location_id = p_supply_demand_line_id