DBA Data[Home] [Help]

APPS.FLM_LOGICAL_KANBAN dependencies on INV_KANBAN_PVT

Line 173: IF (kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier ) THEN

169: l_partial_rcvd_qty := 0;
170: FOR kanban_rec IN kanban_cur(pull_seq_rec.pull_sequence_id) LOOP
171: IF kanban_rec.card_status = 1 and trunc(kanban_rec.supply_status) = 5 THEN -- Active and Inprocess
172: BEGIN
173: IF (kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier ) THEN
174: SELECT Nvl(pda.quantity_delivered,0)
175: INTO l_received_quantity
176: FROM mtl_kanban_card_activity mkca,
177: po_distributions_all pda

Line 190: IF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_InterOrg THEN

186: FROM mtl_kanban_card_activity
187: WHERE kanban_card_id = kanban_rec.kanban_card_id);
188: ELSE
189:
190: IF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_InterOrg THEN
191: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_INTREQ; --7
192: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg THEN
193: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER; --4
194: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Production THEN

Line 192: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg THEN

188: ELSE
189:
190: IF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_InterOrg THEN
191: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_INTREQ; --7
192: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg THEN
193: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER; --4
194: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Production THEN
195: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_WIP; --5
196: END IF;

Line 194: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Production THEN

190: IF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_InterOrg THEN
191: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_INTREQ; --7
192: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg THEN
193: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_MOVEORDER; --4
194: ELSIF kanban_rec.source_type = INV_Kanban_PVT.G_Source_Type_Production THEN
195: l_transaction_source_type_id := INV_GLOBALS.G_SOURCETYPE_WIP; --5
196: END IF;
197:
198: SELECT Nvl(Sum(mmt.transaction_quantity),0)