DBA Data[Home] [Help]

APPS.INV_LABEL_PVT13 dependencies on MTL_PARAMETERS

Line 76: l_organization_code mtl_parameters.organization_code%TYPE;

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

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

166: and gbsi.batchstep_id = gbs.batchstep_id
167: and gbsi.material_detail_id = bl.material_detail_id
168: and go.oprn_id = gbs.oprn_id) batch_line
169:
170: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,
171: mtl_system_items_vl msi
172: where bh.batch_id = p_batch_id AND -- 121706
173: bl.organization_id = mp.organization_id AND
174: bh.batch_id = bl.batch_id AND

Line 230: mtl_parameters mp,

226: and gbsi.material_detail_id = bl.material_detail_id
227: and go.oprn_id = gbs.oprn_id) batch_line,
228: mmt.transfer_lpn_id
229: FROM gme_batch_header_vw bh,
230: mtl_parameters mp,
231: gme_material_details bl,
232: mtl_system_items_vl msi,
233: mtl_material_transactions mmt,
234: mtl_transaction_lot_numbers mtln,

Line 297: mtl_parameters mp,

293: and gbsi.material_detail_id = bl.material_detail_id
294: and go.oprn_id = gbs.oprn_id) batch_line
295:
296: FROM gme_batch_header_vw bh,
297: mtl_parameters mp,
298: gme_material_details bl,
299: mtl_system_items_vl msi,
300: gme_pending_product_lots gppl,
301: po_hazard_classes hzc,