DBA Data[Home] [Help]

APPS.INV_LABEL_PVT13 dependencies on MTL_ITEM_LOCATIONS_KFV

Line 101: l_locator mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;

97: l_reason_id NUMBER;
98: l_uom2 VARCHAR2(3);
99: l_reason_name mtl_transaction_reasons.reason_name%TYPE;
100: l_hazard_class po_hazard_classes.hazard_class%TYPE;
101: l_locator mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
102: l_count NUMBER;
103:
104: l_parent_lot_number VARCHAR2(80);
105: l_grade_code VARCHAR2(150);

Line 235: mtl_item_locations_kfv milk,

231: gme_material_details bl,
232: mtl_system_items_vl msi,
233: mtl_material_transactions mmt,
234: mtl_transaction_lot_numbers mtln,
235: mtl_item_locations_kfv milk,
236: mtl_transaction_reasons mtr,
237: po_hazard_classes hzc
238: where mmt.transaction_id = p_transaction_id and -- 12409734 and --
239: bh.batch_id = mmt.TRANSACTION_SOURCE_ID AND -- 121706