APPS.CST_EAMCOST_PUB dependencies on PO_REQUISITION_HEADERS_ALL

Line 3071: po_requisition_headers_all prha,

3067: prha.last_update_date category_date,
3068: null, /* Bug 5201970 */
3069: null /* Bug 5201970 */
3070: FROM po_requisition_lines_all prla,
3071: po_requisition_headers_all prha,
3072: cst_eam_direct_items_temp wediv
3073: WHERE wediv.work_order_number = p_wip_entity_id
3074: AND wediv.organization_id = l_organization_id
3075: AND wediv.task_number = prla.wip_operation_seq_num

Line 5174: po_requisition_headers_all prha,

5170: prla.item_description item_description,
5171: prla.item_id item_id,
5172: cedi.req_authorization_status req_auth_status
5173: FROM po_requisition_lines_all prla,
5174: po_requisition_headers_all prha,
5175: cst_eam_direct_items_temp cedi
5176: WHERE cedi.work_order_number = p_wip_entity_id
5177: AND cedi.organization_id = l_organization_id
5178: AND cedi.task_number = prla.wip_operation_seq_num

Line 10740: FROM po_requisition_headers_all rqh,

10736: rqh.authorization_status,
10737: rqh.requisition_header_id,
10738: rql.requisition_line_id,
10739: rql.closed_code
10740: FROM po_requisition_headers_all rqh,
10741: po_requisition_lines_all rql,
10742: po_req_distributions_all rqd
10743: WHERE rql.requisition_header_id = rqh.requisition_header_id AND
10744: rqd.requisition_line_id = rql.requisition_line_id AND

Line 10804: po_requisition_headers_all rqh,

10800: rqh.type_lookup_code, -- DOCUMENT_TYPE
10801: to_char(null) -- IS_SHARED_PROC
10802: FROM
10803: po_requisition_lines_all rql,
10804: po_requisition_headers_all rqh,
10805: po_line_types plt,
10806: mtl_units_of_measure uom,
10807: wip_eam_direct_items wed,
10808: hr_organization_information hoi,