DBA Data[Home] [Help]

APPS.RCV_AVAILABILITY dependencies on RCV_SUPPLY

Line 263: rcv_supply rs

259: rsl.unit_of_measure,
260: rsl.primary_unit_of_measure,
261: rsl.to_organization_id
262: FROM rcv_shipment_lines rsl,
263: rcv_supply rs
264: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
265: AND ( p_organization_id IS NULL
266: OR p_organization_id = rsl.to_organization_id)
267: AND ( p_item_id IS NULL

Line 350: rcv_supply rs

346: rsl.unit_of_measure,
347: rsl.primary_unit_of_measure,
348: rsl.to_organization_id
349: FROM rcv_shipment_lines rsl,
350: rcv_supply rs
351: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
352: AND ( p_organization_id IS NULL
353: OR p_organization_id = rsl.to_organization_id)
354: AND ( p_item_id IS NULL

Line 448: rcv_supply rs

444: rsl.unit_of_measure,
445: rsl.primary_unit_of_measure,
446: rsl.to_organization_id
447: FROM rcv_shipment_lines rsl,
448: rcv_supply rs
449: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
450: AND ( p_organization_id IS NULL
451: OR p_organization_id = rsl.to_organization_id)
452: AND ( p_item_id IS NULL

Line 565: rcv_supply rs

561: rsl.unit_of_measure,
562: rsl.primary_unit_of_measure,
563: rsl.to_organization_id
564: FROM rcv_shipment_lines rsl,
565: rcv_supply rs
566: WHERE rsl.shipment_line_id = rs.shipment_line_id(+)
567: AND ( p_organization_id IS NULL
568: OR p_organization_id = rsl.to_organization_id)
569: AND ( p_item_id IS NULL