[Home] [Help]
3029: pla.category_id category_id,
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
5127: plla.line_location_id line_location_id,
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
6271: into l_actual_res_rate,
6272: l_curr_rate,
6273: l_curr_code,
6274: l_po_order_type_lookup_code
6275: from po_distributions_all pod,
6276: rcv_transactions_interface rti,
6277: po_lines_all pol
6278: where rti.interface_transaction_id = l_interface_txn_id
6279: and pod.po_distribution_id = rti.po_distribution_id
6371: l_directItem_rec.wip_entity_id,
6372: l_item_id,
6373: l_source_doc_unit_of_measure
6374: from rcv_transactions rti,
6375: po_distributions_all pod,
6376: po_lines_all pol
6377: where rti.transaction_id = l_txn_id
6378: and rti.po_distribution_id = pod.po_distribution_id
6379: and pol.po_line_id = pod.po_line_id;
6556: l_directItem_rec.transaction_uom,
6557: l_directItem_rec.usage_rate_or_amount,
6558: l_directItem_rec.wip_entity_id
6559: from rcv_transactions_interface rti,
6560: po_distributions_all pod,
6561: mtl_units_of_measure muom,
6562: mtl_units_of_measure puom
6563: where rti.interface_transaction_id = l_interface_txn_id
6564: and rti.po_distribution_id = pod.po_distribution_id
7528: p_prg_id,
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
9298:
9299: If (l_po_dist_id <> -1) then
9300: select po_release_id
9301: into l_po_release_id
9302: from po_distributions_all
9303: where po_distribution_id=l_po_dist_id
9304: and po_header_id= l_po_header_id;
9305:
9306:
10655: pd1.po_header_id,
10656: pd1.project_id,
10657: pol.org_id
10658: FROM po_lines_all pol,
10659: po_distributions_all pd1
10660: WHERE pol.po_line_id = pd1.po_line_id AND
10661: pd1.wip_entity_id = p_entity_id_tab(l_index)
10662: ) pd
10663: WHERE
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
11129: AND POH.po_header_id = RT.po_header_id
11130: AND POLL.line_location_id = RT.po_line_location_id