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 GMO_MATERIAL_DISPENSES

Line 84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;

80:
81: l_locator mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
82: l_count NUMBER;
83:
84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;
85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;
86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;

Line 85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;

81: l_locator mtl_item_locations_kfv.CONCATENATED_SEGMENTS%TYPE;
82: l_count NUMBER;
83:
84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;
85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;
86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;

Line 86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;

82: l_count NUMBER;
83:
84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;
85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;
86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;

Line 87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;

83:
84: l_dispense_id gmo_material_dispenses.dispense_id%TYPE;
85: l_dispense_source gmo_material_dispenses.dispense_source%TYPE;
86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;

Line 90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;

86: l_dispense_number gmo_material_dispenses.dispense_number%TYPE;
87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;

Line 91: l_organization_id gmo_material_dispenses.organization_id%TYPE;

87: l_dispense_type gmo_material_dispenses.dispense_type%TYPE;
88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;

Line 92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;

88: l_batchstep_no gme_batch_steps.batchstep_no%TYPE;
89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);

Line 93: l_security_code gmo_material_dispenses.security_code%TYPE;

89: l_oprn_no gmd_operations.oprn_no%TYPE;
90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);
97: l_mode varchar2(100);

Line 94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;

90: l_inventory_item_id gmo_material_dispenses.inventory_item_id%TYPE;
91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);
97: l_mode varchar2(100);
98: l_required_qty gmo_material_dispenses.required_qty%TYPE;

Line 95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;

91: l_organization_id gmo_material_dispenses.organization_id%TYPE;
92: l_subinventory gmo_material_dispenses.subinventory_code%TYPE;
93: l_security_code gmo_material_dispenses.security_code%TYPE;
94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);
97: l_mode varchar2(100);
98: l_required_qty gmo_material_dispenses.required_qty%TYPE;
99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;

Line 98: l_required_qty gmo_material_dispenses.required_qty%TYPE;

94: l_dispense_uom gmo_material_dispenses.dispense_uom%TYPE;
95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);
97: l_mode varchar2(100);
98: l_required_qty gmo_material_dispenses.required_qty%TYPE;
99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;
100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;

Line 99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;

95: l_undispense_uom gmo_material_dispenses.dispense_uom%TYPE;
96: l_dispensed_date varchar2(100);
97: l_mode varchar2(100);
98: l_required_qty gmo_material_dispenses.required_qty%TYPE;
99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;
100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;

Line 101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;

97: l_mode varchar2(100);
98: l_required_qty gmo_material_dispenses.required_qty%TYPE;
99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;
100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;

Line 102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;

98: l_required_qty gmo_material_dispenses.required_qty%TYPE;
99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;
100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;

Line 103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;

99: l_dispensed_qty gmo_material_dispenses.dispensed_qty%TYPE;
100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;

Line 104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;

100:
101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;

Line 105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;

101: l_gross_required_weight gmo_material_dispenses.gross_required_weight%TYPE;
102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:

Line 106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;

102: l_source_container_tare gmo_material_dispenses.source_container_tare%TYPE;
103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:
110: l_lot_number gmo_material_dispenses.lot_number%TYPE;

Line 107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;

103: l_source_container_weight gmo_material_dispenses.source_container_weight%TYPE;
104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:
110: l_lot_number gmo_material_dispenses.lot_number%TYPE;
111: l_hazard_class po_hazard_classes.hazard_class%TYPE;

Line 108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;

104: l_source_container_reweight gmo_material_dispenses.source_container_reweight%TYPE;
105: l_actual_gross_weight gmo_material_dispenses.actual_gross_weight%TYPE;
106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:
110: l_lot_number gmo_material_dispenses.lot_number%TYPE;
111: l_hazard_class po_hazard_classes.hazard_class%TYPE;
112:

Line 110: l_lot_number gmo_material_dispenses.lot_number%TYPE;

106: l_target_container_tare gmo_material_dispenses.target_container_tare%TYPE;
107: l_source_container_item_id gmo_material_dispenses.source_container_item_id%TYPE;
108: l_target_container_item_id gmo_material_dispenses.target_container_item_id%TYPE;
109:
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;

Line 119: l_undispense_source gmo_material_dispenses.dispense_source%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;
123: l_negation_qty NUMBER;

Line 187: gmo_material_dispenses d, gme_batch_header bh,

183: d.lot_number,
184: hzc.hazard_class,
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

Line 233: gmo_material_dispenses d, gme_batch_header bh,

229: und.undispense_id,
230: (nvl(und.undispensed_qty,0) + nvl(und.material_loss,0)) undispensed_qty,
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