DBA Data[Home] [Help]

APPS.INV_LABEL_PVT11 dependencies on GMO_MATERIAL_UNDISPENSES

Line 114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;

110: l_lot_number gmo_material_dispenses.lot_number%TYPE;
111: l_hazard_class po_hazard_classes.hazard_class%TYPE;
112:
113: /*** undispense ****/
114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;
115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;
116: l_undispense_type gmo_material_undispenses.undispense_type%TYPE;
117: l_undispensed_date varchar2(100);
118: l_undispensed_qty gmo_material_undispenses.undispensed_qty%TYPE;

Line 115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;

111: l_hazard_class po_hazard_classes.hazard_class%TYPE;
112:
113: /*** undispense ****/
114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;
115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;
116: l_undispense_type gmo_material_undispenses.undispense_type%TYPE;
117: l_undispensed_date varchar2(100);
118: l_undispensed_qty gmo_material_undispenses.undispensed_qty%TYPE;
119: l_undispense_source gmo_material_dispenses.dispense_source%TYPE;

Line 116: l_undispense_type gmo_material_undispenses.undispense_type%TYPE;

112:
113: /*** undispense ****/
114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;
115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;
116: l_undispense_type gmo_material_undispenses.undispense_type%TYPE;
117: l_undispensed_date varchar2(100);
118: l_undispensed_qty gmo_material_undispenses.undispensed_qty%TYPE;
119: l_undispense_source gmo_material_dispenses.dispense_source%TYPE;
120:

Line 118: l_undispensed_qty gmo_material_undispenses.undispensed_qty%TYPE;

114: l_undispense_id gmo_material_undispenses.undispense_id%TYPE;
115: l_undispense_number gmo_material_undispenses.undispense_number%TYPE;
116: l_undispense_type gmo_material_undispenses.undispense_type%TYPE;
117: l_undispensed_date varchar2(100);
118: l_undispensed_qty gmo_material_undispenses.undispensed_qty%TYPE;
119: l_undispense_source gmo_material_dispenses.dispense_source%TYPE;
120:
121:
122: l_material_qty NUMBER;

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