DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on PO_REQUISITION_HEADERS_ALL

Line 2849: po_requisition_headers_all prha,

2845: prha.last_update_date category_date,
2846: null, /* Bug 5201970 */
2847: null /* Bug 5201970 */
2848: FROM po_requisition_lines_all prla,
2849: po_requisition_headers_all prha,
2850: cst_eam_direct_items_temp wediv
2851: WHERE wediv.work_order_number = p_wip_entity_id
2852: AND wediv.organization_id = l_organization_id
2853: AND wediv.task_number = prla.wip_operation_seq_num

Line 4952: po_requisition_headers_all prha,

4948: prla.item_description item_description,
4949: prla.item_id item_id,
4950: cedi.req_authorization_status req_auth_status
4951: FROM po_requisition_lines_all prla,
4952: po_requisition_headers_all prha,
4953: cst_eam_direct_items_temp cedi
4954: WHERE cedi.work_order_number = p_wip_entity_id
4955: AND cedi.organization_id = l_organization_id
4956: AND cedi.task_number = prla.wip_operation_seq_num

Line 10027: FROM po_requisition_headers_all rqh,

10023: rqh.authorization_status,
10024: rqh.requisition_header_id,
10025: rql.requisition_line_id,
10026: rql.closed_code
10027: FROM po_requisition_headers_all rqh,
10028: po_requisition_lines_all rql,
10029: po_req_distributions_all rqd
10030: WHERE rql.requisition_header_id = rqh.requisition_header_id AND
10031: rqd.requisition_line_id = rql.requisition_line_id AND

Line 10091: po_requisition_headers_all rqh,

10087: rqh.type_lookup_code, -- DOCUMENT_TYPE
10088: to_char(null) -- IS_SHARED_PROC
10089: FROM
10090: po_requisition_lines_all rql,
10091: po_requisition_headers_all rqh,
10092: po_line_types plt,
10093: mtl_units_of_measure uom,
10094: wip_eam_direct_items wed,
10095: hr_organization_information hoi,