APPS.CTO_UTILITY_PK dependencies on MRP_SR_ASSIGNMENTS

Line 1779: -- a full table scan on MRP_SR_ASSIGNMENTS and consequent

1775: --
1776: -- bug 6617686
1777: -- The MRP API uses a ASSIGNMENT_ID = p_Assignment_Id OR
1778: -- ASSIGNMENT_SET_ID = p_Assignment_Set_Id that leads to
1779: -- a full table scan on MRP_SR_ASSIGNMENTS and consequent
1780: -- performance issues. Since CTO does not pass ASSIGNMENT_SET_ID
1781: -- into the procedure, it is performance effective to directly
1782: -- query the MRP table
1783: -- ntungare

Line 1861: FROM MRP_SR_ASSIGNMENTS

1857: , lAssignmentRec.SECONDARY_INVENTORY
1858: , lAssignmentRec.SHIP_TO_SITE_ID
1859: , lAssignmentRec.SOURCING_RULE_ID
1860: , lAssignmentRec.SOURCING_RULE_TYPE
1861: FROM MRP_SR_ASSIGNMENTS
1862: WHERE ASSIGNMENT_ID = lAssignmentId;
1863:
1864: IF PG_DEBUG <> 0 THEN
1865: oe_debug_pub.add('populate_plan_level: ' || 'after query row',2);

Line 1896: from mrp_sr_assignments

1892: -- bug 6617686
1893: IF pConfigId IS NOT NULL THEN
1894: select 1
1895: into lAssignmentExists
1896: from mrp_sr_assignments
1897: where assignment_set_id = lAssignmentRec.assignment_set_id
1898: and assignment_type = lAssignmentRec.assignment_type
1899: and nvl(organization_id,-1) = nvl(lAssignmentRec.organization_id,-1)
1900: and nvl(customer_id,-1) = nvl(lAssignmentRec.customer_id,-1)

Line 1908: from mrp_sr_assignments

1904: and nvl(category_id,-1) = nvl(lAssignmentRec.category_id,-1);
1905: ELSE
1906: select 1
1907: into lAssignmentExists
1908: from mrp_sr_assignments
1909: where assignment_set_id = lAssignmentRec.assignment_set_id
1910: and assignment_type = lAssignmentRec.assignment_type
1911: and nvl(organization_id,-1) = nvl(lAssignmentRec.organization_id,-1)
1912: and nvl(customer_id,-1) = nvl(lAssignmentRec.customer_id,-1)

Line 1941: SELECT mrp_sr_assignments_s.nextval

1937:
1938: --
1939: -- get assignment id for config item
1940: --
1941: SELECT mrp_sr_assignments_s.nextval
1942: INTO lConfigAssignmentId
1943: FROM DUAL;
1944:
1945: --