APPS.FLM_MULTIPLE_SUPPLIERS dependencies on INV_KANBAN_PVT

Line 97: AND mkc.card_status(+) in ( INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold)

93: WHERE mks.pull_sequence_id = p_pull_seq_id
94: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
95: AND mks.supplier_id = mkc.supplier_id(+)
96: AND Nvl(mks.supplier_site_id, -1 ) = Nvl(mkc.supplier_site_id(+) ,-1)
97: AND mkc.card_status(+) in ( INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold)
98: GROUP BY mks.supplier_id, mks.supplier_site_id , mks.organization_id, mks.number_of_cards , mks.creation_date
99: ORDER BY mks.creation_date;
100:
101: CURSOR multiple_suppliers_plancur IS

Line 114: AND mkc.card_status in ( INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned)

110: WHERE mks.pull_sequence_id = p_pull_seq_id
111: AND mks.pull_sequence_id = mkc.pull_sequence_id(+)
112: AND mks.supplier_id = mkc.supplier_id(+)
113: and NVL(MKS.SUPPLIER_SITE_ID, -1 ) = NVL(MKC.SUPPLIER_SITE_ID(+) ,-1)
114: AND mkc.card_status in ( INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold,INV_Kanban_PVT.G_Card_Status_Planned)
115: GROUP BY mks.supplier_id, mks.supplier_site_id , mks.organization_id, mks.future_no_of_cards , mks.creation_date
116: ORDER BY mks.creation_date;
117:
118: TYPE mul_suprecord is RECORD ( supplier_id NUMBER,

Line 194: IF p_cardstatus=INV_Kanban_PVT.G_Card_Status_Planned THEN

190: * 1. Check the supplier which has max deficiency of its existing cards than its required cards
191: * 2. If there are many suppliers with equal deficient cards - then select the supplier with maximum number of required cards
192: * 3. If there is a tie - then select the first supplier from the pull sequence
193: */
194: IF p_cardstatus=INV_Kanban_PVT.G_Card_Status_Planned THEN
195: OPEN multiple_suppliers_plancur;
196: FETCH multiple_suppliers_plancur BULK COLLECT INTO mul_sup_rec;
197: CLOSE multiple_suppliers_plancur;
198: ELSE