DBA Data[Home] [Help]

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 235: mtl_system_items_vl msi, po_hazard_classes hzc , gmo_material_undispenses und

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

Line 422: from mtl_system_items_vl

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

Line 432: from mtl_system_items_vl

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