DBA Data[Home] [Help]

APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on MTL_SYSTEM_ITEMS

Line 636: FROM mtl_system_items

632: lot_control_code
633: INTO l_rcv_txn_rec.uom,
634: l_serial_code,
635: l_lot_code
636: FROM mtl_system_items
637: WHERE inventory_item_id = rcvtxn_rec.item_id
638: AND organization_id = rcvtxn_rec.organization_id;
639:
640: l_rcv_txn_rec.rcv_transaction_id := rcvtxn_rec.transaction_id;

Line 769: FROM mtl_system_items_kfv

765: l_Operating_Unit NUMBER;
766:
767: CURSOR item_name_cur(p_item_id IN number, p_org_id IN number) IS
768: SELECT concatenated_segments
769: FROM mtl_system_items_kfv
770: WHERE inventory_item_id = p_item_id
771: AND organization_id = p_org_id;
772:
773: CURSOR project_name_cur(p_project_id IN NUMBER) IS