DBA Data[Home] [Help]

APPS.CTO_CONFIG_ROUTING_PK dependencies on MTL_PARAMETERS

Line 383: mtl_parameters mp

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

Line 504: mtl_parameters mp

500: into lEstRelDate
501: from bom_calendar_dates cal,
502: mtl_system_items msi,
503: bom_cto_order_lines bcol,
504: mtl_parameters mp
505: where msi.organization_id = pOrgId
506: and msi.inventory_item_id = pModelId
507: and bcol.line_id = pLineId
508: and bcol.inventory_item_id = msi.inventory_item_id

Line 636: mtl_parameters mp

632: bor.project_id,
633: bor.task_id
634: from
635: bom_operational_routings bor,
636: mtl_parameters mp
637: where bor.assembly_item_id = pModelId
638: and bor.organization_id = pOrgId
639: and bor.alternate_routing_designator is null
640: and mp.organization_id = pOrgId;

Line 2542: mtl_parameters mp

2538: NULL, /* ATTRIBUTE13 */
2539: NULL, /* ATTRIBUTE14 */
2540: NULL /* ATTRIBUTE15 */
2541: from bom_operational_routings bor,
2542: mtl_parameters mp
2543: where bor.routing_sequence_id = lCfgRtgId
2544: and bor.organization_id = mp.organization_id;
2545:
2546: /*------------------------------------------------+