APPS.MRP_LAUNCH_PLAN_PK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

	| Update mrp_plans with plan horizon date |
	+----------------------------------------*/

        IF G_MRP_DEBUG = 'Y' THEN /*2663505*/

	MRP_UTIL.Mrp_Debug('******About to Launch Plan******');

Line: 48

		UPDATE mrp_plans
		SET   	curr_cutoff_date = var_new_date,
		plan_completion_date = NULL,
		data_completion_date = NULL
		WHERE   organization_id = arg_org_id
		AND    compile_designator = arg_compile_desig;

Line: 58

		UPDATE mrp_plans
		SET    curr_cutoff_date = var_new_date,
		plan_completion_date = NULL,
		data_completion_date = NULL
		WHERE  organization_id = arg_org_id
		AND    compile_designator = arg_compile_desig;

Line: 67

	| Update mrp_parameters with anchor date |
	+---------------------------------------*/
	UPDATE mrp_parameters
	SET    repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
	WHERE  organization_id IN (select planned_organization
								from mrp_plan_organizations_v
								where organization_id = arg_org_id
								and compile_designator = arg_compile_desig);

Line: 84

	| Insert subinventories into mrp_sub_inventories |
	| that are defined after options are defined     |
	+-----------------------------------------------*/
   BEGIN
	   INSERT INTO MRP_SUB_INVENTORIES
				(SUB_INVENTORY_CODE,
				 ORGANIZATION_ID,
				 COMPILE_DESIGNATOR,
				 CREATION_DATE,
				 CREATED_BY,
				 LAST_UPDATE_LOGIN,
				 LAST_UPDATE_DATE,
				 LAST_UPDATED_BY,
				 NETTING_TYPE)
		   SELECT  msi.secondary_inventory_name,
			mpo.planned_organization,
			arg_compile_desig,
			SYSDATE,
			1,
			-1,
			SYSDATE,
			1,
			msi.availability_type
		   FROM    MTL_SECONDARY_INVENTORIES msi,
				   mrp_plan_organizations_v mpo
			 WHERE   NOT EXISTS
				(SELECT NULL
				 FROM MRP_SUB_INVENTORIES SUB
				 WHERE SUB.ORGANIZATION_ID = mpo.planned_organization
				 AND SUB.COMPILE_DESIGNATOR = mpo.compile_designator
				 AND SUB.sub_inventory_code = msi.SECONDARY_INVENTORY_NAME)
				 AND NVL(MSI.DISABLE_DATE, SYSDATE + 1) > TRUNC(SYSDATE)
		AND msi.ORGANIZATION_ID = mpo.planned_organization
		and mpo.organization_id = arg_org_id
		and mpo.compile_designator = arg_compile_desig;

Line: 182

	SELECT NVL(production, SYS_NO)
	INTO   var_production1
	FROM   mrp_designators
	WHERE  organization_id = arg_org_id
	AND    compile_designator = arg_compile_desig;

Line: 192

	SELECT NVL(production, SYS_NO)
	INTO   var_production2
	FROM   mrp_schedule_designators
	WHERE  organization_id = arg_org_id
	AND    schedule_designator = arg_compile_desig;