DBA Data[Home] [Help]

APPS.PO_BUYER_WORKLOAD_SV dependencies on PO_REQUISITION_HEADERS

Line 118: FROM PO_REQUISITION_HEADERS PORH

114: AND (x_approval_status_list IS NULL
115: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
116: OR x_approval_status_list =
117: (SELECT authorization_status
118: FROM PO_REQUISITION_HEADERS PORH
119: WHERE PORH.requisition_header_id =
120: PORL.requisition_header_id))
121: AND (x_requisition_header_id IS NULL
122: OR PORL.requisition_header_id = x_requisition_header_id)

Line 284: FROM PO_REQUISITION_HEADERS PORH

280: AND (x_approval_status_list IS NULL
281: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
282: OR x_approval_status_list =
283: (SELECT authorization_status
284: FROM PO_REQUISITION_HEADERS PORH
285: WHERE PORH.requisition_header_id =
286: PORL.requisition_header_id))
287: AND (x_requisition_header_id IS NULL
288: OR PORL.requisition_header_id = x_requisition_header_id)

Line 460: FROM PO_REQUISITION_HEADERS PORH

456: AND (x_approval_status_list IS NULL
457: OR x_approval_status_list = 'ALL' /*Bug 5717983 This is to consider the 'All Statuses' option.*/
458: OR x_approval_status_list =
459: (SELECT authorization_status
460: FROM PO_REQUISITION_HEADERS PORH
461: WHERE PORH.requisition_header_id =
462: PORL.requisition_header_id))
463: AND (x_requisition_header_id IS NULL
464: OR PORL.requisition_header_id = x_requisition_header_id)