68: +---------------------------------------*/
69: UPDATE mrp_parameters
70: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
71: WHERE organization_id IN (select planned_organization
72: from mrp_plan_organizations_v
73: where organization_id = arg_org_id
74: and compile_designator = arg_compile_desig);
75:
76: COMMIT;
104: SYSDATE,
105: 1,
106: msi.availability_type
107: FROM MTL_SECONDARY_INVENTORIES msi,
108: mrp_plan_organizations_v mpo
109: WHERE NOT EXISTS
110: (SELECT NULL
111: FROM MRP_SUB_INVENTORIES SUB
112: WHERE SUB.ORGANIZATION_ID = mpo.planned_organization