DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 2812: po_line_locations_all plla,

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

Line 4910: po_line_locations_all plla,

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

Line 10009: FROM po_line_locations_all poll

10005: l_stmt_num := 20;
10006:
10007: UPDATE cst_eam_direct_items_temp cedi
10008: SET TXN_FLOW_HEADER_ID =(SELECT transaction_flow_header_id
10009: FROM po_line_locations_all poll
10010: WHERE poll.line_location_id = cedi.line_location_id)
10011: WHERE cedi.line_location_id is not null;
10012:
10013: