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 774: FROM mtl_system_items_kfv

770:
771:
772: CURSOR item_name_cur(p_item_id IN number, p_org_id IN number) IS
773: SELECT concatenated_segments
774: FROM mtl_system_items_kfv
775: WHERE inventory_item_id = p_item_id
776: AND organization_id = p_org_id;
777:
778: CURSOR project_name_cur(p_project_id IN NUMBER) IS