DBA Data[Home] [Help]

APPS.FLM_RECEIPT_PUB dependencies on RCV_SHIPMENT_LINES

Line 111: FROM rcv_shipment_lines rsl,

107: IS
108: SELECT COUNT(rsl.shipment_line_id) num_of_ship_lines,
109: SUM(rsl.quantity_shipped) quantity_shipped,
110: SUM(rsl.quantity_received) quantity_received
111: FROM rcv_shipment_lines rsl,
112: mtl_kanban_cards mkc,
113: mtl_kanban_card_activity mkca
114: WHERE rsl.requisition_line_id = mkca.document_detail_id
115: AND mkca.kanban_card_id = mkc.kanban_card_id

Line 927: FROM rcv_shipment_lines rsl,

923: msi.serial_number_control_code,
924: rsl.country_of_origin_code,
925: rsl.cost_group_id,
926: porl.org_id
927: FROM rcv_shipment_lines rsl,
928: po_requisition_lines_all porl,
929: mtl_system_items msi,
930: mtl_units_of_measure muom,
931: mtl_kanban_cards mkc,