eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVDX dependencies on MTL_MATERIAL_TRANSACTIONS

Line 69: , x_transaction_set_id OUT NOCOPY mtl_material_transactions.transaction_set_id%TYPE

65: , p_lot_rec_tbl IN lot_type_tbl
66: , x_hdr_row OUT NOCOPY gmi_discrete_transfers%ROWTYPE
67: , x_line_row_tbl OUT NOCOPY line_row_tbl
68: , x_lot_row_tbl OUT NOCOPY lot_row_tbl
69: , x_transaction_set_id OUT NOCOPY mtl_material_transactions.transaction_set_id%TYPE
70: )
71: IS
72: l_api_name CONSTANT VARCHAR2(30) := 'Create_transfer_pvt' ;
73: l_api_version CONSTANT NUMBER := 1.0 ;

Line 1890: update mtl_material_transactions

1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;
1888:
1889: --everything is good. set costed flag to yes in mmt
1890: update mtl_material_transactions
1891: set costed_flag = 'Y',
1892: opm_costed_flag = 'Y'
1893: where transaction_set_id = p_hdr_rec.transaction_header_id;
1894:

Line 1900: where inventory_item_id = (select inventory_item_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id)

1896: --rlnagara 2 Material Status Migration ME start - Added the below code to update the status in MOQD
1897: select lot_control_code, lot_status_enabled
1898: into l_lot_ctl, l_lot_sts
1899: from mtl_system_items_b
1900: where inventory_item_id = (select inventory_item_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id)
1901: and organization_id = (select organization_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id);
1902:
1903: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN
1904: update mtl_onhand_quantities_detail

Line 1901: and organization_id = (select organization_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id);

1897: select lot_control_code, lot_status_enabled
1898: into l_lot_ctl, l_lot_sts
1899: from mtl_system_items_b
1900: where inventory_item_id = (select inventory_item_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id)
1901: and organization_id = (select organization_id from mtl_material_transactions where transaction_set_id = p_hdr_rec.transaction_header_id);
1902:
1903: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN
1904: update mtl_onhand_quantities_detail
1905: set status_id = (select status_id from mtl_material_statuses

Line 1907: where transfer_id = (select transaction_source_id from mtl_material_transactions

1903: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN
1904: update mtl_onhand_quantities_detail
1905: set status_id = (select status_id from mtl_material_statuses
1906: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots
1907: where transfer_id = (select transaction_source_id from mtl_material_transactions
1908: where transaction_set_id = p_hdr_rec.transaction_header_id)) )
1909: where create_transaction_id = (select transaction_id from mtl_material_transactions
1910: where transaction_set_id = p_hdr_rec.transaction_header_id) ;
1911: END IF;

Line 1909: where create_transaction_id = (select transaction_id from mtl_material_transactions

1905: set status_id = (select status_id from mtl_material_statuses
1906: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots
1907: where transfer_id = (select transaction_source_id from mtl_material_transactions
1908: where transaction_set_id = p_hdr_rec.transaction_header_id)) )
1909: where create_transaction_id = (select transaction_id from mtl_material_transactions
1910: where transaction_set_id = p_hdr_rec.transaction_header_id) ;
1911: END IF;
1912: --rlnagara 2 Material Status Migration ME end.
1913: