APPS.FLM_EKB_UNMOVED_CARDS SQL Statements

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

Line: 59

        select  organization_id
        Bulk Collect
        into    l_all_orgs
        from    MTL_PARAMETERS;

Line: 80

        select  organization_id
        into    p_organization_id
        from    MTL_PARAMETERS
        where   organization_code = p_organization_code;

Line: 106

l_update_required		varchar2(1) := 'Y';

Line: 139

select
	CREATION_DATE,
	SUPPLY_STATUS
FROM 	MTL_KANBAN_CARD_ACTIVITY
WHERE 	KANBAN_ACTIVITY_ID = ( Select MAX(KANBAN_ACTIVITY_ID)
				from 	MTL_KANBAN_CARD_ACTIVITY MKCA
				WHERE 	KANBAN_CARD_ID = l_card_id );

Line: 149

Select
        MKCA.CREATION_DATE,
        MKCA.KANBAN_ACTIVITY_ID,
        MKC.SUPPLY_STATUS,
        MKPS.PULL_SEQUENCE_ID,
        MKC.KANBAN_CARD_ID,
        MKPS.ORGANIZATION_ID,
        MKPS.REPLENISHMENT_LEAD_TIME
FROM    MTL_KANBAN_PULL_SEQUENCES MKPS , MTL_KANBAN_CARDS MKC,
	MTL_KANBAN_CARD_ACTIVITY MKCA
where   MKPS.ORGANIZATION_ID = p_organization_id
and     MKPS.PULL_SEQUENCE_ID = MKC.PULL_SEQUENCE_ID
and     MKPS.REPLENISHMENT_LEAD_TIME  > 0
and     MKPS.KANBAN_PLAN_ID = -1
and     MKC.CARD_STATUS in (1,2)   -- Exclude Calculation for Cancelled and Planned Cards. Bug 14311023
and 	MKCA.KANBAN_ACTIVITY_ID = ( Select MAX(MKCA1.KANBAN_ACTIVITY_ID)
                                from    MTL_KANBAN_CARD_ACTIVITY MKCA1
                                WHERE   MKCA1.KANBAN_CARD_ID = MKC.KANBAN_CARD_ID
				AND	MKCA1.SUPPLY_STATUS = MKC.SUPPLY_STATUS)
ORDER BY MKPS.PULL_SEQUENCE_ID;

Line: 172

Update	MTL_KANBAN_CARDS
Set	MOVE_STATUS = null
where	pull_sequence_id in ( select pull_sequence_id from
MTL_KANBAN_PULL_SEQUENCES where ORGANIZATION_ID = p_organization_id );

Line: 181

	select 	Organization_code
	into	l_organization_code
	from 	mtl_parameters
	where	organization_id = p_organization_id;

Line: 289

				Update	MTL_KANBAN_CARDS
				SET	MOVE_STATUS = 1,
					LAST_STATUS_CHANGE_DATE = c_ps_activity.CREATION_DATE,
					LAST_UPDATE_DATE = sysdate,
					LAST_UPDATED_BY = G_USER_ID
				Where 	PULL_SEQUENCE_ID = c_ps_activity.pull_sequence_id
				and	kanban_card_id = c_ps_activity.kanban_card_id;

Line: 311

                Update  MTL_KANBAN_CARDS
                SET     MOVE_STATUS = x_uc_from_custom(i).unmoved_flag,
                LAST_STATUS_CHANGE_DATE = x_uc_from_custom(i).last_activity_date,
                LAST_UPDATE_DATE = sysdate,
                LAST_UPDATED_BY = G_USER_ID
                Where   PULL_SEQUENCE_ID = l_pull_sequence_id
                and     kanban_card_id = x_uc_from_custom(i).kanban_card_id;

Line: 341

				Update	MTL_KANBAN_CARDS
				SET	MOVE_STATUS = 1,
					LAST_STATUS_CHANGE_DATE = c_ps_activity.CREATION_DATE,
					LAST_UPDATE_DATE = sysdate,
					LAST_UPDATED_BY = G_USER_ID
				Where 	PULL_SEQUENCE_ID = x_pull_sequence_id
				and	kanban_card_id = c_ps_activity.kanban_card_id;

Line: 364

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

Line: 370

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
	,null
	,null
	,sysdate
	,G_REQUEST_ID
	,sysdate
	,G_USER_ID
	,G_USER_ID
	,sysdate
	,G_LOGIN_ID
);

Line: 404

Update 	flm_ekb_run_details
set	Unmoved_cards_run_date = sysdate,
	Last_Unmoved_cards_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: 420

select count(move_status)
into l_row_count
from mtl_kanban_cards
where Move_status = 1;