DBA Data[Home] [Help]

APPS.FLM_RECEIPT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 81: FROM mtl_system_items msi

77: CURSOR c_item_details(p_item_id IN NUMBER, p_organization_id IN NUMBER)
78: IS
79: SELECT msi.lot_control_code,
80: msi.serial_number_control_code
81: FROM mtl_system_items msi
82: WHERE msi.inventory_item_id = p_item_id
83: AND msi.organization_id = p_organization_id;
84:
85: -- Cursor to fetch PO details for source type supplier

Line 515: mtl_system_items_vl msi,

511: FROM po_headers_all poh,
512: po_lines_all pol,
513: po_line_locations_all poll,
514: po_distributions_all pod,
515: mtl_system_items_vl msi,
516: mtl_units_of_measure muom,
517: mtl_kanban_cards mkc,
518: mtl_kanban_card_activity mkca
519: WHERE poh.po_header_id = pol.po_header_id

Line 929: mtl_system_items msi,

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,
932: mtl_kanban_card_activity mkca
933: WHERE rsl.requisition_line_id = porl.requisition_line_id