DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 921: po_requisition_headers_all rqh,

917: rql.wip_entity_id,
918: rql.quantity quantity_ordered,
919: to_number(null) quantity_received
920: FROM po_requisition_lines_all rql,
921: po_requisition_headers_all rqh,
922: po_line_types plt
923: WHERE rql.requisition_header_id = rqh.requisition_header_id
924: AND rql.line_type_id = plt.line_type_id
925: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')

Line 1222: po_requisition_headers_all rqh,

1218: rql.wip_entity_id,
1219: rql.quantity quantity_ordered,
1220: to_number(null) quantity_received
1221: FROM po_requisition_lines_all rql,
1222: po_requisition_headers_all rqh,
1223: po_line_types plt
1224: WHERE rql.requisition_header_id = rqh.requisition_header_id
1225: AND rql.line_type_id = plt.line_type_id
1226: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')

Line 1532: po_requisition_headers_all rqh,

1528: rql.wip_entity_id,
1529: rql.quantity quantity_ordered,
1530: to_number(null) quantity_received
1531: FROM po_requisition_lines_all rql,
1532: po_requisition_headers_all rqh,
1533: po_line_types plt
1534: WHERE rql.requisition_header_id = rqh.requisition_header_id
1535: AND rql.line_type_id = plt.line_type_id
1536: AND upper(rqh.authorization_status) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')