APPS.CST_EAMCOST_PUB dependencies on PO_LINES_ALL

Line 2814: po_lines_all pla,

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
2818: AND wediv.task_number = pda.wip_operation_seq_num

Line 4912: po_lines_all pla,

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
4916: AND cedi.task_number = pda.wip_operation_seq_num

Line 5972: po_lines_all pol

5968: l_curr_code,
5969: l_po_order_type_lookup_code
5970: from po_distributions_all pod,
5971: rcv_transactions_interface rti,
5972: po_lines_all pol
5973: where rti.interface_transaction_id = l_interface_txn_id
5974: and pod.po_distribution_id = rti.po_distribution_id
5975: and pol.po_header_id=pod.po_header_id
5976: and pol.po_line_id=pod.po_line_id; */

Line 6059: po_lines_all pol

6055: l_item_id,
6056: l_source_doc_unit_of_measure
6057: from rcv_transactions rti,
6058: po_distributions_all pod,
6059: po_lines_all pol
6060: where rti.transaction_id = l_txn_id
6061: and rti.po_distribution_id = pod.po_distribution_id
6062: and pol.po_line_id = pod.po_line_id;
6063:

Line 8696: from po_lines_all pla

8692: l_statement := 70;
8693: if (l_po_line_id <> -1) then
8694: select nvl(pla.category_id, -1)
8695: into l_category_id
8696: from po_lines_all pla
8697: where pla.po_line_id = l_po_line_id;
8698: else
8699: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8700: l_api_message := l_api_message || ' wip_cost_txn_interface ';

Line 8952: from po_lines_all pla

8948: l_statement := 70;
8949: if (l_po_line_id <> -1) then
8950: select nvl(pla.category_id, -1)
8951: into l_category_id
8952: from po_lines_all pla
8953: where pla.po_line_id = l_po_line_id;
8954: else
8955: l_api_message := 'No po_line_id exist for transaction ID: ' || TO_CHAR(p_txn_id);
8956: l_api_message := l_api_message || ' wip_transactions ';

Line 9945: FROM po_lines_all pol,

9941: pol.line_type_id,
9942: pd1.po_header_id,
9943: pd1.project_id,
9944: pol.org_id
9945: FROM po_lines_all pol,
9946: po_distributions_all pd1
9947: WHERE pol.po_line_id = pd1.po_line_id AND
9948: pd1.wip_entity_id = p_entity_id_tab(l_index)
9949: ) pd