DBA Data[Home] [Help]

APPS.INV_LABEL_PVT13 dependencies on MTL_PARAMETERS

Line 73: l_organization_code mtl_parameters.organization_code%TYPE;

69: l_plan_cmplt_date varchar2(100);
70: l_actual_cmplt_date varchar2(100);
71: l_batch_close_date varchar2(100)
72: ;
73: l_organization_code mtl_parameters.organization_code%TYPE;
74:
75: l_planned_qty gme_material_details.plan_qty%TYPE;
76: l_uom gme_material_details.dtl_um%TYPE;
77: l_actual_qty gme_material_details.plan_qty%TYPE;

Line 165: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,

161: and gbsi.batchstep_id = gbs.batchstep_id
162: and gbsi.material_detail_id = bl.material_detail_id
163: and go.oprn_id = gbs.oprn_id) batch_line
164:
165: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,
166: mtl_system_items_vl msi
167: where bh.batch_id = p_batch_id AND -- 121706
168: bl.organization_id = mp.organization_id AND
169: bh.batch_id = bl.batch_id AND

Line 222: mtl_parameters mp,

218: and gbsi.material_detail_id = bl.material_detail_id
219: and go.oprn_id = gbs.oprn_id) batch_line
220:
221: FROM gme_batch_header_vw bh,
222: mtl_parameters mp,
223: gme_material_details bl,
224: mtl_system_items_vl msi,
225: mtl_material_transactions mmt,
226: mtl_transaction_lot_numbers mtln,

Line 288: mtl_parameters mp,

284: and gbsi.material_detail_id = bl.material_detail_id
285: and go.oprn_id = gbs.oprn_id) batch_line
286:
287: FROM gme_batch_header_vw bh,
288: mtl_parameters mp,
289: gme_material_details bl,
290: mtl_system_items_vl msi,
291: gme_pending_product_lots gppl,
292: po_hazard_classes hzc,