DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on MTL_PARAMETERS

Line 382: mtl_parameters mp

378: into lEstRelDate
379: from bom_calendar_dates cal,
380: mtl_system_items msi,
381: bom_cto_order_lines bcol,
382: mtl_parameters mp
383: where msi.organization_id = pOrgId
384: and msi.inventory_item_id = pModelId
385: and bcol.line_id = pLineId
386: and bcol.inventory_item_id = msi.inventory_item_id

Line 515: mtl_parameters mp

511: into lEstRelDate
512: from bom_calendar_dates cal,
513: mtl_system_items msi,
514: bom_cto_order_lines bcol,
515: mtl_parameters mp
516: where msi.organization_id = pOrgId
517: and msi.inventory_item_id = pModelId
518: and bcol.line_id = pLineId
519: and bcol.inventory_item_id = msi.inventory_item_id

Line 648: mtl_parameters mp

644: bor.project_id,
645: bor.task_id
646: from
647: bom_operational_routings bor,
648: mtl_parameters mp
649: where bor.assembly_item_id = pModelId
650: and bor.organization_id = pOrgId
651: and bor.alternate_routing_designator is null
652: and mp.organization_id = pOrgId;

Line 2551: mtl_parameters mp

2547: NULL, /* ATTRIBUTE13 */
2548: NULL, /* ATTRIBUTE14 */
2549: NULL /* ATTRIBUTE15 */
2550: from bom_operational_routings bor,
2551: mtl_parameters mp
2552: where bor.routing_sequence_id = lCfgRtgId
2553: and bor.organization_id = mp.organization_id;
2554:
2555: /*------------------------------------------------+