eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT11 dependencies on MTL_SYSTEM_ITEMS_VL

Line 66: l_item mtl_system_items_vl.concatenated_segments%TYPE;

62: l_batch_no gme_batch_header.batch_no%TYPE;
63:
64: l_organization mtl_parameters.organization_code%TYPE;
65:
66: l_item mtl_system_items_vl.concatenated_segments%TYPE;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;
69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;
70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;

Line 67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;

63:
64: l_organization mtl_parameters.organization_code%TYPE;
65:
66: l_item mtl_system_items_vl.concatenated_segments%TYPE;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;
69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;
70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;
71:

Line 68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;

64: l_organization mtl_parameters.organization_code%TYPE;
65:
66: l_item mtl_system_items_vl.concatenated_segments%TYPE;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;
69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;
70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;
71:
72: l_quantity NUMBER := 0;

Line 69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;

65:
66: l_item mtl_system_items_vl.concatenated_segments%TYPE;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;
69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;
70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;
71:
72: l_quantity NUMBER := 0;
73: l_revision mtl_material_transactions.revision%TYPE;

Line 70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;

66: l_item mtl_system_items_vl.concatenated_segments%TYPE;
67: l_source_container_item mtl_system_items_vl.concatenated_segments%TYPE;
68: l_target_container_item mtl_system_items_vl.concatenated_segments%TYPE;
69: l_dispensed_container mtl_system_items_vl.concatenated_segments%TYPE;
70: l_material_container mtl_system_items_vl.concatenated_segments%TYPE;
71:
72: l_quantity NUMBER := 0;
73: l_revision mtl_material_transactions.revision%TYPE;
74: l_item_description VARCHAR2(240) := NULL;

Line 189: mtl_system_items_vl msi, po_hazard_classes hzc

185: d.inventory_item_id
186: from
187: gmo_material_dispenses d, gme_batch_header bh,
188: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,
189: mtl_system_items_vl msi, po_hazard_classes hzc
190: where d.dispense_id = p_transaction_id AND
191: d.batch_id = bh.batch_id AND
192: d.organization_id = mp.organization_id AND
193: d.batch_step_id = bs.batchstep_id(+) AND

Line 236: mtl_system_items_vl msi, po_hazard_classes hzc , gmo_material_undispenses und

232: und.inventory_item_id
233: from
234: gmo_material_dispenses d, gme_batch_header bh,
235: gme_batch_steps bs, mtl_parameters mp, gmd_operations gop,
236: mtl_system_items_vl msi, po_hazard_classes hzc , gmo_material_undispenses und
237: where und.undispense_id = p_transaction_id AND
238: und.dispense_id = d.dispense_id AND
239: und.batch_id = bh.batch_id AND
240: und.organization_id = mp.organization_id AND

Line 423: from mtl_system_items_vl

419: IF l_source_container_item_id IS NOT NULL
420: THEN
421: Select concatenated_segments
422: INTO l_source_container_item
423: from mtl_system_items_vl
424: where organization_id = l_organization_id AND
425: inventory_item_id = l_source_container_item_id;
426: END IF;
427:

Line 433: from mtl_system_items_vl

429: IF l_target_container_item_id IS NOT NULL
430: THEN
431: Select concatenated_segments
432: INTO l_target_container_item
433: from mtl_system_items_vl
434: where organization_id = l_organization_id AND
435: inventory_item_id = l_target_container_item_id;
436: END IF;
437: