[Home] [Help]
2807: pla.category_id category_id,
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
4905: plla.line_location_id line_location_id,
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
5966: into l_actual_res_rate,
5967: l_curr_rate,
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
6054: l_directItem_rec.wip_entity_id,
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;
6202: l_directItem_rec.transaction_uom,
6203: l_directItem_rec.usage_rate_or_amount,
6204: l_directItem_rec.wip_entity_id
6205: from rcv_transactions_interface rti,
6206: po_distributions_all pod,
6207: mtl_units_of_measure muom,
6208: mtl_units_of_measure puom
6209: where rti.interface_transaction_id = l_interface_txn_id
6210: and rti.po_distribution_id = pod.po_distribution_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
9950: WHERE