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 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