APPS.PO_REQ_LINES_SV dependencies on PO_REQUISITION_LINES_ALL

Line 655: UPDATE po_requisition_lines_all -- Bug 3592153

651: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
652: AND s.po_header_id = X_entity_id;
653: --
654:
655: UPDATE po_requisition_lines_all -- Bug 3592153
656: SET line_location_id = NULL,
657: reqs_in_pool_flag = 'Y', -- Bug 2781027 resetting the reqs in pool flag
658: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
659: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 681: UPDATE po_requisition_lines_all -- Bug 3592153

677: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
678: AND s.po_release_id = X_entity_id;
679: --
680:
681: UPDATE po_requisition_lines_all -- Bug 3592153
682: SET line_location_id = NULL,
683: reqs_in_pool_flag = 'Y', -- Bug 2781027
684: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
685: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 706: UPDATE po_requisition_lines_all -- Bug 3592153

702: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
703: AND s.po_line_id = X_entity_id;
704: --
705:
706: UPDATE po_requisition_lines_all -- Bug 3592153
707: SET line_location_id = NULL,
708: reqs_in_pool_flag = 'Y', -- Bug 2781027
709: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
710: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 731: UPDATE po_requisition_lines_all -- Bug 3592153

727: WHERE s.line_location_id = rl.line_location_id and nvl(rl.drop_ship_flag, 'N') = 'Y'
728: AND s.line_location_id = X_entity_id;
729: --
730:
731: UPDATE po_requisition_lines_all -- Bug 3592153
732: SET line_location_id = NULL,
733: reqs_in_pool_flag = 'Y', -- Bug 2781027
734: last_update_login = fnd_global.login_id, -- Bug5623016 (updating who column)
735: last_updated_by = fnd_global.user_id, -- Bug5623016 (updating who column)

Line 1115: UPDATE po_requisition_lines_all prl

1111: -- be placed on a purchasing document; those that fail all
1112: -- the above criteria can.
1113: --
1114: --SQL Join: requisition_header_id from PO_REQUISITION_HEADERS_ALL
1115: UPDATE po_requisition_lines_all prl
1116: SET prl.reqs_in_pool_flag =
1117: CASE
1118: WHEN NVL(prl.cancel_flag,'N') = 'Y'
1119: OR NVL(prl.closed_code,'OPEN') = 'FINALLY CLOSED'

Line 1143: FROM PO_REQUISITION_LINES_ALL SUB

1139: , prl.last_update_login = FND_GLOBAL.LOGIN_ID
1140: WHERE
1141: PRL.Requisition_Line_ID in (
1142: SELECT SUB.Requisition_Line_ID
1143: FROM PO_REQUISITION_LINES_ALL SUB
1144: WHERE SUB.Requisition_Header_Id = x_req_header_id
1145: AND x_req_line_id IS NULL
1146: UNION ALL
1147: SELECT SUB2.Requisition_Line_ID

Line 1148: FROM PO_REQUISITION_LINES_ALL SUB2

1144: WHERE SUB.Requisition_Header_Id = x_req_header_id
1145: AND x_req_line_id IS NULL
1146: UNION ALL
1147: SELECT SUB2.Requisition_Line_ID
1148: FROM PO_REQUISITION_LINES_ALL SUB2
1149: WHERE SUB2.Requisition_Line_Id = x_req_line_id
1150: );
1151:
1152: ELSE