[Home] [Help]
106: l_selling_org_id,
107: l_customer_id,
108: l_order_type_id
109: FROM oe_order_headers_all oeh,
110: oe_order_lines_all oel
111: WHERE oel.line_id = p_order_line_id
112: AND oel.header_id = oeh.header_id;
113:
114: IF (l_debug = 1) THEN
873: l_organization_id,
874: l_item_id,
875: l_transaction_date
876: FROM hr_organization_information hoi,
877: oe_order_lines_all oola,
878: mtl_material_transactions mmt
879: WHERE mmt.transaction_id = p_transaction_id
880: AND mmt.trx_source_line_id = oola.line_id
881: AND oola.ship_from_org_id = hoi.organization_id
1954: SELECT mso.sales_order_id
1955: INTO l_mtl_trx_tbl(1).transaction_source_id
1956: FROM mtl_sales_orders mso,
1957: oe_order_headers_all ooha,
1958: oe_order_lines_all oola
1959: WHERE oola.line_id = l_mtl_trx_tbl(1).trx_source_line_id
1960: AND oola.header_id = ooha.header_id
1961: AND ooha.order_number = mso.segment1;
1962: *****/
4564: -- Because of this, form is unable to find the req and throwing No Data Found error and
4565: -- unable to query and logical intransit receipts at all.
4566: --
4567: -- Now we are setting the source_code to 'RCV' and getting the requisition_header_id
4568: -- from oe_order_lines_all table, so that form can query the txn.
4569: -- Txn_Source_Line_Id column should get updated when actual receipt of goods is made.
4570: --
4571: l_source_code := 'RCV';
4572:
4577: ol.source_document_id -- Requisition_header_id
4578: -- requisition_line_id = ol.source_document_line_id
4579: INTO
4580: l_transaction_source_id
4581: FROM mtl_material_transactions mmt, oe_order_lines_all ol
4582: WHERE mmt.transaction_id = p_transaction_id
4583: AND ol.line_id = mmt.trx_source_line_id
4584: ;
4585: ELSE