APPS.CST_EAMCOST_PUB dependencies on PO_HEADERS_ALL

Line 2813: po_headers_all pha,

2809: pha.type_lookup_code, /* Bug 5201970 */
2810: wediv.po_release_id /* Bug 5201970 */
2811: FROM po_distributions_all pda,
2812: po_line_locations_all plla,
2813: po_headers_all pha,
2814: po_lines_all pla,
2815: cst_eam_direct_items_temp wediv
2816: WHERE wediv.work_order_number = p_wip_entity_id
2817: AND wediv.organization_id = l_organization_id

Line 4911: po_headers_all pha,

4907: pla.item_id item_id,
4908: cedi.req_authorization_status req_auth_status
4909: FROM po_distributions_all pda,
4910: po_line_locations_all plla,
4911: po_headers_all pha,
4912: po_lines_all pla,
4913: cst_eam_direct_items_temp cedi
4914: WHERE cedi.work_order_number = p_wip_entity_id
4915: AND cedi.organization_id = l_organization_id

Line 8678: from po_headers_all pha

8674: select pha.approved_date,
8675: type_lookup_code
8676: into l_approved_date,
8677: l_type_lookup_code
8678: from po_headers_all pha
8679: where pha.po_header_id = l_po_header_id;
8680: else
8681: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8682: l_api_message := l_api_message || ' wip_cost_txn_interface ';

Line 8934: from po_headers_all pha

8930: l_statement := 60;
8931: if (l_po_header_id <> -1) then
8932: select pha.approved_date
8933: into l_approved_date
8934: from po_headers_all pha
8935: where pha.po_header_id = l_po_header_id;
8936: else
8937: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8938: l_api_message := l_api_message || ' wip_transactions ';

Line 9913: po_headers_all poh,

9909: to_char(null) -- IS_SHARED_PROC
9910: FROM
9911: po_line_types plt,
9912: mtl_units_of_measure uom,
9913: po_headers_all poh,
9914: wip_eam_direct_items wed,
9915: hr_organization_information hoi,
9916: wip_operations wo,
9917: (SELECT