DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on RCV_SUPPLY

Line 308: rcv_supply rs

304: rsl.unit_of_measure,
305: rsl.primary_unit_of_measure,
306: rsl.to_organization_id
307: FROM rcv_shipment_lines rsl,
308: rcv_supply rs
309: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
310: AND ( p_organization_id IS NULL
311: OR p_organization_id = rsl.to_organization_id)
312: AND ( p_item_id IS NULL

Line 395: rcv_supply rs

391: rsl.unit_of_measure,
392: rsl.primary_unit_of_measure,
393: rsl.to_organization_id
394: FROM rcv_shipment_lines rsl,
395: rcv_supply rs
396: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
397: AND ( p_organization_id IS NULL
398: OR p_organization_id = rsl.to_organization_id)
399: AND ( p_item_id IS NULL

Line 493: rcv_supply rs

489: rsl.unit_of_measure,
490: rsl.primary_unit_of_measure,
491: rsl.to_organization_id
492: FROM rcv_shipment_lines rsl,
493: rcv_supply rs
494: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
495: AND ( p_organization_id IS NULL
496: OR p_organization_id = rsl.to_organization_id)
497: AND ( p_item_id IS NULL

Line 610: rcv_supply rs

606: rsl.unit_of_measure,
607: rsl.primary_unit_of_measure,
608: rsl.to_organization_id
609: FROM rcv_shipment_lines rsl,
610: rcv_supply rs
611: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
612: AND ( p_organization_id IS NULL
613: OR p_organization_id = rsl.to_organization_id)
614: AND ( p_item_id IS NULL