APPS.CST_EAMCOST_PUB dependencies on PO_HEADERS_ALL

Line 3035: po_headers_all pha,

3031: pha.type_lookup_code, /* Bug 5201970 */
3032: wediv.po_release_id /* Bug 5201970 */
3033: FROM po_distributions_all pda,
3034: po_line_locations_all plla,
3035: po_headers_all pha,
3036: po_lines_all pla,
3037: cst_eam_direct_items_temp wediv
3038: WHERE wediv.work_order_number = p_wip_entity_id
3039: AND wediv.organization_id = l_organization_id

Line 5133: po_headers_all pha,

5129: pla.item_id item_id,
5130: cedi.req_authorization_status req_auth_status
5131: FROM po_distributions_all pda,
5132: po_line_locations_all plla,
5133: po_headers_all pha,
5134: po_lines_all pla,
5135: cst_eam_direct_items_temp cedi
5136: WHERE cedi.work_order_number = p_wip_entity_id
5137: AND cedi.organization_id = l_organization_id

Line 7533: po_headers_all poh,

7529: sysdate,
7530: DECODE(p_acct_line_type,15,encumbrance_type_id,NULL) --Bug 9356654 WIP Encumbrance enhancement Change 3
7531: FROM wip_cost_txn_interface wcti,
7532: po_distributions_all pod,
7533: po_headers_all poh,
7534: rcv_transactions rt,
7535: fnd_currencies fc
7536: WHERE wcti.transaction_id = p_txn_id
7537: AND poh.po_header_id = wcti.po_header_id

Line 9260: from po_headers_all pha

9256: select pha.approved_date,
9257: type_lookup_code
9258: into l_approved_date,
9259: l_type_lookup_code
9260: from po_headers_all pha
9261: where pha.po_header_id = l_po_header_id;
9262: else
9263: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9264: l_api_message := l_api_message || ' wip_cost_txn_interface ';

Line 9578: from po_headers_all pha

9574: l_statement := 60;
9575: if (l_po_header_id <> -1) then
9576: select pha.approved_date
9577: into l_approved_date
9578: from po_headers_all pha
9579: where pha.po_header_id = l_po_header_id;
9580: else
9581: l_api_message := 'No po_header_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
9582: l_api_message := l_api_message || ' wip_transactions ';

Line 10626: po_headers_all poh,

10622: to_char(null) -- IS_SHARED_PROC
10623: FROM
10624: po_line_types plt,
10625: mtl_units_of_measure uom,
10626: po_headers_all poh,
10627: wip_eam_direct_items wed,
10628: hr_organization_information hoi,
10629: wip_operations wo,
10630: (SELECT

Line 11041: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;

11037: l_rcv_organization_id NUMBER;
11038: l_category_id NUMBER;
11039: l_project_id NUMBER;
11040: l_accrual_flag VARCHAR2(1) := 'N';
11041: l_po_document_type_code PO_HEADERS_ALL.type_lookup_code%TYPE;
11042: l_cross_ou_flag VARCHAR2(1) := 'N' ;
11043: l_rcv_org_id NUMBER;
11044: l_rcv_sob_id NUMBER;
11045: l_procurement_org_flag VARCHAR2(1) := 'Y';

Line 11123: FROM po_headers_all POH,

11119: l_project_id,
11120: l_accrual_flag,
11121: l_po_document_type_code,
11122: l_po_encumbrance_amount
11123: FROM po_headers_all POH,
11124: po_line_locations_all POLL,
11125: po_lines_all POL,
11126: po_distributions_all POD,
11127: rcv_transactions RT