DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 3034: po_line_locations_all plla,

3030: nvl(pha.approved_date, pha.last_update_date) category_date,
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

Line 5132: po_line_locations_all plla,

5128: pla.item_description item_description,
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

Line 10722: FROM po_line_locations_all poll

10718: l_stmt_num := 20;
10719:
10720: UPDATE cst_eam_direct_items_temp cedi
10721: SET TXN_FLOW_HEADER_ID =(SELECT transaction_flow_header_id
10722: FROM po_line_locations_all poll
10723: WHERE poll.line_location_id = cedi.line_location_id)
10724: WHERE cedi.line_location_id is not null;
10725:
10726:

Line 11124: po_line_locations_all POLL,

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
11128: WHERE RT.transaction_id = p_receiving_transaction_id