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 GMI_DISCRETE_TRANSFER_LOTS

Line 127: --and gmi_discrete_transfer_lots. |

123: END IF;
124:
125: --if the validation of header, lines and lots is successful then
126: --lets construct and post records to gmi_discrete_transfers, gmi_discrete_transfers |
127: --and gmi_discrete_transfer_lots. |
128: --In this call, we will also create lots in OPM and ODM if the lot does not exist.
129: --Transaction tables in OPM/ODM and onhand balcnces in OPM/ODM would also be updated.
130:
131: construct_post_records

Line 1653: | and gmi_discrete_transfer_lots. |

1649: | |
1650: | USAGE |
1651: | constructs and posts process/discrete transfer records to |
1652: | tables gmi_discrete_transfers, gmi_discrete_transfers |
1653: | and gmi_discrete_transfer_lots. |
1654: | It will also create lots in OPM and ODM if the lot does not exist. |
1655: | It would created transactions and update balances in OPM inventory |
1656: | and Oracle Inventory |
1657: | |

Line 1913: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots

1909:
1910: IF l_lot_ctl = 2 and l_lot_sts = 'Y' THEN
1911: update mtl_onhand_quantities_detail
1912: set status_id = (select status_id from mtl_material_statuses
1913: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots
1914: where transfer_id = (select transaction_source_id from mtl_material_transactions
1915: where transaction_set_id = p_hdr_rec.transaction_header_id)) )
1916: where create_transaction_id = (select transaction_id from mtl_material_transactions
1917: where transaction_set_id = p_hdr_rec.transaction_header_id) ;