APPS.FLM_EKB_HEALTH_STATUS SQL Statements

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

Line: 41

        select  organization_id
        Bulk Collect
        into    l_all_orgs
        from    MTL_PARAMETERS;

Line: 62

        select  organization_id
        into    p_organization_id
        from    MTL_PARAMETERS
        where   organization_code = p_organization_code;

Line: 89

l_update_required		varchar2(1) := 'Y';

Line: 106

select
	COUNT(KANBAN_CARD_ID) Total_cards,
	nvl(SUM(KANBAN_SIZE),0) Total_size
FROM 	MTL_KANBAN_CARDS
WHERE 	PULL_SEQUENCE_ID = l_pull_sequence_id
AND   	SUPPLY_STATUS >= 2 AND SUPPLY_STATUS < 3 --Supply Status Full
AND     CARD_STATUS in (1,2); /*Bug 14262914:Only considering Active and Hold card*/

Line: 116

Select
	PULL_SEQUENCE_ID,
	ORGANIZATION_ID,
	((nvl(AVG_DEPENDENT_DEMAND,0) + nvl(AVG_INDEPENDENT_DEMAND,0)) * nvl(SAFETY_STOCK_DAYS,0)) SAFETY_STOCK
FROM 	MTL_KANBAN_PULL_SEQUENCES
where 	ORGANIZATION_ID = p_organization_id
and	SAFETY_STOCK_DAYS  > 0
and kanban_plan_id = -1;

Line: 201

changed update of INV_HEALTH_STATUS accordingly*/

if l_health >= l_good_health then
	UPDATE	MTL_KANBAN_PULL_SEQUENCES
	SET	INV_HEALTH_STATUS = 2, --Warning
		LAST_UPDATE_DATE = sysdate,
		LAST_UPDATED_BY = G_USER_ID
	WHERE	PULL_SEQUENCE_ID = l_pull_sequence_id;

Line: 210

	UPDATE	MTL_KANBAN_PULL_SEQUENCES
	SET	INV_HEALTH_STATUS = 1, --Bad
		LAST_UPDATE_DATE = sysdate,
		LAST_UPDATED_BY = G_USER_ID
	WHERE	PULL_SEQUENCE_ID = l_pull_sequence_id;

Line: 216

	UPDATE	MTL_KANBAN_PULL_SEQUENCES
	SET	INV_HEALTH_STATUS = 3, --Good
		LAST_UPDATE_DATE = sysdate,
		LAST_UPDATED_BY = G_USER_ID
	WHERE	PULL_SEQUENCE_ID = l_pull_sequence_id;

Line: 228

select 	count(*)
into	l_row_count
from 	flm_ekb_run_details
where 	organization_id = p_organization_id;

Line: 234

insert into flm_ekb_run_details(
	Organization_id,
	Actual_demand_run_date,
	Last_demand_request_id,
	Lead_time_run_date,
	Last_lead_time_request_id,
	Health_status_run_date,
	Last_Health_status_request_id,
	Unmoved_cards_run_date,
	Last_Unmoved_cards_request_id,
	creation_date,
	created_by,
	last_updated_by,
	last_update_date,
	last_update_login
	)
values(p_organization_id
	,null
	,null
	,null
	,null
	,sysdate
	,G_REQUEST_ID
	,null
	,null
	,sysdate
	,G_USER_ID
	,G_USER_ID
	,sysdate
	,G_LOGIN_ID
);

Line: 268

Update 	flm_ekb_run_details
set	Health_status_run_date = sysdate,
	Last_Health_status_request_id = G_REQUEST_ID,
        last_updated_by = G_USER_ID,
        last_update_date = sysdate,
        last_update_login = G_LOGIN_ID
where 	organization_id = p_organization_id;

Line: 284

select count(*)
into l_row_count
from mtl_kanban_pull_sequences
where INV_HEALTH_STATUS = 1
and  organization_id = p_organization_id;

Line: 293

select count(*)
into l_row_count
from mtl_kanban_pull_sequences
where INV_HEALTH_STATUS = 2
and  organization_id = p_organization_id;

Line: 302

select count(*)
into l_row_count
from mtl_kanban_pull_sequences
where INV_HEALTH_STATUS = 3
and  organization_id = p_organization_id;