DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on OE_ORDER_LINES_ALL

Line 126: oe_order_lines_all oel

122: l_selling_org_id,
123: l_customer_id,
124: l_order_type_id
125: FROM oe_order_headers_all oeh,
126: oe_order_lines_all oel
127: WHERE oel.line_id = p_order_line_id
128: AND oel.header_id = oeh.header_id;
129:
130: IF (l_debug = 1) THEN

Line 893: oe_order_lines_all oola,

889: l_organization_id,
890: l_item_id,
891: l_transaction_date
892: FROM hr_organization_information hoi,
893: oe_order_lines_all oola,
894: mtl_material_transactions mmt
895: WHERE mmt.transaction_id = p_transaction_id
896: AND mmt.trx_source_line_id = oola.line_id
897: AND oola.ship_from_org_id = hoi.organization_id

Line 1975: oe_order_lines_all oola

1971: SELECT mso.sales_order_id
1972: INTO l_mtl_trx_tbl(1).transaction_source_id
1973: FROM mtl_sales_orders mso,
1974: oe_order_headers_all ooha,
1975: oe_order_lines_all oola
1976: WHERE oola.line_id = l_mtl_trx_tbl(1).trx_source_line_id
1977: AND oola.header_id = ooha.header_id
1978: AND ooha.order_number = mso.segment1;
1979: *****/

Line 4655: -- from oe_order_lines_all table, so that form can query the txn.

4651: -- Because of this, form is unable to find the req and throwing No Data Found error and
4652: -- unable to query and logical intransit receipts at all.
4653: --
4654: -- Now we are setting the source_code to 'RCV' and getting the requisition_header_id
4655: -- from oe_order_lines_all table, so that form can query the txn.
4656: -- Txn_Source_Line_Id column should get updated when actual receipt of goods is made.
4657: --
4658: l_source_code := 'RCV';
4659:

Line 4668: FROM mtl_material_transactions mmt, oe_order_lines_all ol

4664: ol.source_document_id -- Requisition_header_id
4665: -- requisition_line_id = ol.source_document_line_id
4666: INTO
4667: l_transaction_source_id
4668: FROM mtl_material_transactions mmt, oe_order_lines_all ol
4669: WHERE mmt.transaction_id = p_transaction_id
4670: AND ol.line_id = mmt.trx_source_line_id
4671: ;
4672: ELSE