APPS.INV_LABEL_PVT10 dependencies on BOM_OPERATIONAL_ROUTINGS

Line 298: p_inventory_item_id bom_operational_routings.assembly_item_id%TYPE,

294:
295: /*=================================================================*/
296: PROCEDURE get_data_bom_routing(
297: x_out_tbl IN OUT NOCOPY output_tbl_type,
298: p_inventory_item_id bom_operational_routings.assembly_item_id%TYPE,
299: p_organization_id bom_operational_routings.organization_id%TYPE,
300: p_alternate_routing_designator bom_operational_routings.alternate_routing_designator%TYPE
301: )IS
302:

Line 299: p_organization_id bom_operational_routings.organization_id%TYPE,

295: /*=================================================================*/
296: PROCEDURE get_data_bom_routing(
297: x_out_tbl IN OUT NOCOPY output_tbl_type,
298: p_inventory_item_id bom_operational_routings.assembly_item_id%TYPE,
299: p_organization_id bom_operational_routings.organization_id%TYPE,
300: p_alternate_routing_designator bom_operational_routings.alternate_routing_designator%TYPE
301: )IS
302:
303: CURSOR bom_routing_curs IS

Line 300: p_alternate_routing_designator bom_operational_routings.alternate_routing_designator%TYPE

296: PROCEDURE get_data_bom_routing(
297: x_out_tbl IN OUT NOCOPY output_tbl_type,
298: p_inventory_item_id bom_operational_routings.assembly_item_id%TYPE,
299: p_organization_id bom_operational_routings.organization_id%TYPE,
300: p_alternate_routing_designator bom_operational_routings.alternate_routing_designator%TYPE
301: )IS
302:
303: CURSOR bom_routing_curs IS
304: SELECT

Line 328: FROM BOM_OPERATIONAL_ROUTINGS bom_rte,

324: bom_rte_wl.line_code line_code,
325: bom_rte.total_product_cycle_time,
326: bom_rte_pp.name project_name,
327: bom_rte_pt.task_name
328: FROM BOM_OPERATIONAL_ROUTINGS bom_rte,
329: PA_PROJECTS bom_rte_pp, PA_TASKS bom_rte_pt,
330: WIP_LINES bom_rte_wl
331: WHERE bom_rte.assembly_item_id = p_inventory_item_id
332: AND bom_rte.organization_id = p_organization_id