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 125: --and gmi_discrete_transfer_lots. |

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

Line 1646: | and gmi_discrete_transfer_lots. |

1642: | |
1643: | USAGE |
1644: | constructs and posts process/discrete transfer records to |
1645: | tables gmi_discrete_transfers, gmi_discrete_transfers |
1646: | and gmi_discrete_transfer_lots. |
1647: | It will also create lots in OPM and ODM if the lot does not exist. |
1648: | It would created transactions and update balances in OPM inventory |
1649: | and Oracle Inventory |
1650: | |

Line 1906: where status_code = (select opm_lot_status from gmi_discrete_transfer_lots

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
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) ;