APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1840: from bom_operational_routings b,mtl_pending_item_status m

1836: program_id = p_program_id,
1837: program_update_date = SYSDATE
1838: WHERE routing_sequence_id in(
1839: select b.routing_sequence_id
1840: from bom_operational_routings b,mtl_pending_item_status m
1841: where m.status_code = p_status_code
1842: and m.pending_flag = 'Y'
1843: and m.request_id = p_request_id
1844: -- and b.organization_id = m.organization_id --mbsk: for mast level control

Line 1888: from bom_operational_routings b,mtl_pending_item_status m

1884: program_id = p_program_id,
1885: program_update_date = SYSDATE
1886: WHERE routing_sequence_id in(
1887: select b.routing_sequence_id
1888: from bom_operational_routings b,mtl_pending_item_status m
1889: where m.status_code = p_status_code
1890: and m.pending_flag = 'Y'
1891: and m.request_id = p_request_id
1892: and b.organization_id = m.organization_id

Line 2159: FROM bom_operational_routings

2155: l_return_status VARCHAR2(1);
2156:
2157: CURSOR common_rout IS
2158: SELECT routing_sequence_id,assembly_item_id
2159: FROM bom_operational_routings
2160: WHERE common_routing_sequence_id = l_rout_seq_id
2161: and routing_sequence_id <> l_rout_seq_id;
2162:
2163: BEGIN

Line 2169: FROM bom_operational_routings

2165: x_return_status := FND_API.G_FALSE;
2166:
2167: BEGIN
2168: SELECT routing_sequence_id INTO l_rout_seq_id
2169: FROM bom_operational_routings
2170: WHERE assembly_item_id = p_inventory_item_id
2171: AND organization_id = p_org_id
2172: AND alternate_routing_designator is null; --fix for bug2063209
2173: EXCEPTION