DBA Data[Home] [Help]

APPS.INV_KANBAN_PVT dependencies on PO_REQUISITION_LINES

Line 3865: FROM po_requisition_lines

3861: /*Bug#4490268--If InProcess, then need to check for any pending requsitions/PO/Release*/
3862: ELSIF p_supply_status = INV_Kanban_PVT.G_Supply_Status_InProcess THEN
3863:
3864: SELECT max(requisition_line_id) into l_max_req
3865: FROM po_requisition_lines
3866: WHERE kanban_card_id = p_kanban_card_id;
3867:
3868: BEGIN
3869: SELECT 1 INTO l_req

Line 3876: FROM po_requisition_lines

3872: EXCEPTION
3873: WHEN NO_DATA_FOUND THEN
3874: BEGIN
3875: SELECT 1 INTO l_req
3876: FROM po_requisition_lines
3877: WHERE kanban_card_id = p_kanban_card_id
3878: AND requisition_line_id = l_max_req
3879: AND line_location_id IS NULL;
3880: EXCEPTION

Line 3884: FROM po_requisition_lines prl1

3880: EXCEPTION
3881: WHEN NO_DATA_FOUND THEN
3882: BEGIN
3883: SELECT 1 INTO l_req
3884: FROM po_requisition_lines prl1
3885: WHERE prl1.kanban_card_id = p_kanban_card_id
3886: AND prl1.requisition_line_id = l_max_req
3887: AND prl1.line_location_id IS NOT NULL
3888: AND (EXISTS (SELECT '1' FROM po_headers poh