DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_TXN_REQUEST_LINES

Line 1476: FROM gl_code_combinations_kfv a, org_organization_definitions b, mtl_txn_request_lines c

1472: -- and in MSCA QUERY MO Page, Account LOV shows multiple times the same
1473: -- a/c segments which is incorrect. Hence this distinct.
1474: SELECT DISTINCT a.code_combination_id
1475: , a.concatenated_segments
1476: FROM gl_code_combinations_kfv a, org_organization_definitions b, mtl_txn_request_lines c
1477: WHERE c.header_id = p_moheader_id
1478: AND b.organization_id = p_organization_id
1479: AND a.chart_of_accounts_id = b.chart_of_accounts_id
1480: AND c.to_account_id = a.code_combination_id

Line 1696: FROM mtl_lot_numbers a, mtl_txn_request_lines b,

1692: ,NULL
1693: ,NULL)
1694: )
1695: ) quantity
1696: FROM mtl_lot_numbers a, mtl_txn_request_lines b,
1697: mtl_material_statuses_tl mmst
1698: WHERE b.organization_id = p_organization_id
1699: AND b.inventory_item_id = p_item_id
1700: AND b.lpn_id = p_lpn_id