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.MIGRATE_BATCH dependencies on GME_INVENTORY_TXNS_GTMP

Line 1306: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',

1302: l_load_trans_fail := TRUE;
1303: l_def_lot_id := NULL;
1304:
1305: insert_message (
1306: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',
1307: p_procedure_name => 'check_wip_batches',
1308: p_parameters => 'batch_id = '
1309: || l_batch_header.batch_id
1310: || ' line_id = '

Line 1336: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',

1332: -- for that was already written, and if load_trans failed, it follows that def lot
1333: -- could not be found.
1334: IF l_load_trans_fail = FALSE THEN
1335: insert_message (
1336: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',
1337: p_procedure_name => 'check_wip_batches',
1338: p_parameters => 'batch_id = '
1339: || l_batch_header.batch_id
1340: || ' line_id = '

Line 1636: UPDATE gme_inventory_txns_gtmp

1632: RAISE error_inserting_txn;
1633: END IF;
1634:
1635: /* Now let's indicate in the temporary table about the reversals */
1636: UPDATE gme_inventory_txns_gtmp
1637: SET transaction_no = 2
1638: WHERE trans_id IN
1639: (l_def_lot_id, l_ic_tran_cmp_out.trans_id);
1640: END IF; /* IF l_reversible THEN */

Line 4249: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',

4245: l_load_trans_fail := TRUE;
4246: l_def_lot_id := NULL;
4247:
4248: insert_message (
4249: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',
4250: p_procedure_name => 'check_wip_batches',
4251: p_parameters => 'batch_id = '
4252: || l_batch_header.batch_id
4253: || ' line_id = '

Line 4277: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',

4273: -- for that was already written, and if load_trans failed, it follows that def lot
4274: -- could not be found.
4275: IF l_load_trans_fail = FALSE THEN
4276: insert_message (
4277: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',
4278: p_procedure_name => 'check_wip_batches',
4279: p_parameters => 'batch_id = '
4280: || l_batch_header.batch_id
4281: || ' line_id = '

Line 4431: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',

4427: EXCEPTION
4428: WHEN OTHERS THEN
4429: x_return_status := 'D';
4430: insert_message (
4431: p_table_name => 'gme_inventory_txns_gtmp/ic_tran_pnd',
4432: p_procedure_name => 'SPLIT_TRANS_LINE',
4433: p_parameters => 'Batch ID='
4434: || l_matl.batch_id
4435: || ' Line ID='

Line 4449: FROM gme_inventory_txns_gtmp

4445: x_return_status OUT NOCOPY VARCHAR2
4446: ) IS
4447: CURSOR c_get_init_reversal IS
4448: SELECT *
4449: FROM gme_inventory_txns_gtmp
4450: WHERE transaction_no = 2 AND
4451: trans_qty <>
4452: 0 -- these are already matched up... don't match them again.
4453: ORDER BY line_type,

Line 4464: FROM gme_inventory_txns_gtmp

4460: trans_id;
4461:
4462: CURSOR c_get_match_reversal IS
4463: SELECT *
4464: FROM gme_inventory_txns_gtmp
4465: WHERE transaction_no <> 2 -- Should this be indexed.
4466: ORDER BY line_type,
4467: item_id,
4468: material_detail_id,

Line 4477: FROM gme_inventory_txns_gtmp

4473: trans_id;
4474:
4475: CURSOR c_get_cmplt_zero_def_txns IS
4476: SELECT *
4477: FROM gme_inventory_txns_gtmp
4478: WHERE completed_ind = 1 AND
4479: trans_qty = 0
4480: ORDER BY line_type,
4481: item_id,

Line 4494: FROM gme_inventory_txns_gtmp

4490: p_batch_id IN NUMBER,
4491: p_batch_type IN VARCHAR2
4492: ) IS
4493: SELECT 1
4494: FROM gme_inventory_txns_gtmp
4495: WHERE doc_id = p_batch_id AND
4496: doc_type = p_batch_type AND
4497: ROWNUM = 1;
4498:

Line 4547: ELSE -- Now Populate The GME_INVENTORY_TXNS_GTMP table

4543: CLOSE c_check_mat_transactions;
4544:
4545: IF (l_inv_exists > 0) THEN -- We have Alreay Loaded INV Batch Data
4546: NULL;
4547: ELSE -- Now Populate The GME_INVENTORY_TXNS_GTMP table
4548: -- Should this be in same file as other table routines
4549: /* Clear out the temp table when a new batch is encountered;
4550: -- The code that calls this orders the batches by batch_id so, once a batch
4551: -- is loaded to the temp table, it doesn't have to be loaded for subsequent matl lines;

Line 4554: DELETE FROM gme_inventory_txns_gtmp;

4550: -- The code that calls this orders the batches by batch_id so, once a batch
4551: -- is loaded to the temp table, it doesn't have to be loaded for subsequent matl lines;
4552: -- however, once a new batch_id is started, we know we are done with the old batch, so,
4553: -- we can remove the data from the previous batch. */
4554: DELETE FROM gme_inventory_txns_gtmp;
4555:
4556: insert_inv_txns_gtmp (
4557: p_batch_id => l_batch_id,
4558: p_doc_type => l_doc_type,

Line 4585: UPDATE gme_inventory_txns_gtmp

4581: (l_last_txn.item_id = l_current_txn.item_id) AND
4582: (l_last_txn.whse_code = l_current_txn.whse_code) AND
4583: (l_last_txn.lot_id = l_current_txn.lot_id) AND
4584: (l_last_txn.location = l_current_txn.location) THEN
4585: UPDATE gme_inventory_txns_gtmp
4586: SET transaction_no = 2
4587: WHERE trans_id IN
4588: (l_last_txn.trans_id, l_current_txn.trans_id);
4589:

Line 4599: UPDATE gme_inventory_txns_gtmp

4595: END IF;
4596:
4597: CLOSE c_get_cmplt_zero_def_txns;
4598:
4599: UPDATE gme_inventory_txns_gtmp
4600: SET transaction_no = 2
4601: WHERE ((line_type = -1 AND -- Ingredient
4602: trans_qty > 0
4603: ) OR

Line 4632: UPDATE gme_inventory_txns_gtmp

4628: (init_revs.location = match_revs.location) AND
4629: (init_revs.completed_ind = match_revs.completed_ind) AND
4630: ((init_revs.trans_qty) + (match_revs.trans_qty) = 0)
4631: ) THEN
4632: UPDATE gme_inventory_txns_gtmp
4633: SET transaction_no = 2
4634: WHERE trans_id = match_revs.trans_id;
4635:
4636: EXIT;

Line 4652: p_table_name => 'gme_inventory_txns_gtmp',

4648: EXCEPTION
4649: WHEN no_batch_id THEN
4650: x_return_status := 'E';
4651: insert_message (
4652: p_table_name => 'gme_inventory_txns_gtmp',
4653: p_procedure_name => 'load_trans',
4654: p_parameters => '',
4655: p_message => 'Batch_id not specified for load',
4656: p_error_type => x_return_status

Line 4664: p_table_name => 'gme_inventory_txns_gtmp',

4660: RAISE;
4661: WHEN OTHERS THEN
4662: x_return_status := 'D';
4663: insert_message (
4664: p_table_name => 'gme_inventory_txns_gtmp',
4665: p_procedure_name => 'load_trans',
4666: p_parameters => 'batch_id = ' || l_batch_id,
4667: p_message => SQLERRM -- || ' with pos = ' || l_pos
4668: ,

Line 4684: INSERT INTO gme_inventory_txns_gtmp

4680: l_all_txns VARCHAR2 (100);
4681: BEGIN
4682: x_return_status := FND_API.G_RET_STS_SUCCESS;
4683:
4684: INSERT INTO gme_inventory_txns_gtmp
4685: (trans_id,
4686: item_id,
4687: co_code,
4688: orgn_code,

Line 4778: p_table_name => 'GME_INVENTORY_TXNS_GTMP',

4774: l_all_txns := ' Attempt to insert single transaction.';
4775: END IF;
4776:
4777: insert_message (
4778: p_table_name => 'GME_INVENTORY_TXNS_GTMP',
4779: p_procedure_name => 'INSERT_INV_TXNS_GTMP',
4780: p_parameters => ' Batch_Id=>'
4781: || p_batch_id
4782: || ' Doc Type=>'

Line 4808: v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE

4804:
4805: CURSOR cur_get_def_trans (
4806: v_batch_id pm_btch_hdr_bak.batch_id%TYPE,
4807: v_line_id pm_matl_dtl_bak.line_id%TYPE,
4808: v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE
4809: ) IS
4810: -- The following cursor does not look at lot_id and loct because these were already screened
4811: -- in the cursor which populated gme_inventory_txns_gtmp in load_trans.
4812: SELECT trans_id,

Line 4811: -- in the cursor which populated gme_inventory_txns_gtmp in load_trans.

4807: v_line_id pm_matl_dtl_bak.line_id%TYPE,
4808: v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE
4809: ) IS
4810: -- The following cursor does not look at lot_id and loct because these were already screened
4811: -- in the cursor which populated gme_inventory_txns_gtmp in load_trans.
4812: SELECT trans_id,
4813: whse_code
4814: FROM gme_inventory_txns_gtmp
4815: WHERE doc_id = v_batch_id AND

Line 4814: FROM gme_inventory_txns_gtmp

4810: -- The following cursor does not look at lot_id and loct because these were already screened
4811: -- in the cursor which populated gme_inventory_txns_gtmp in load_trans.
4812: SELECT trans_id,
4813: whse_code
4814: FROM gme_inventory_txns_gtmp
4815: WHERE doc_id = v_batch_id AND
4816: doc_type = v_doc_type AND
4817: material_detail_id = v_line_id AND
4818: transaction_no <> 2 -- don't look at the reversals...

Line 4843: l_doc_type gme_inventory_txns_gtmp.doc_type%TYPE;

4839: get_batch_info cur_get_batch_info%ROWTYPE;
4840: get_trans_rec cur_get_def_trans%ROWTYPE;
4841: l_tran_whse ps_whse_eff.whse_code%TYPE;
4842: l_batch_type pm_btch_hdr_bak.batch_type%TYPE;
4843: l_doc_type gme_inventory_txns_gtmp.doc_type%TYPE;
4844: l_pos NUMBER := 0;
4845: l_cnt NUMBER;
4846: BEGIN
4847: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4875: FROM gme_inventory_txns_gtmp

4871: END IF;
4872:
4873: SELECT COUNT (1)
4874: INTO l_cnt
4875: FROM gme_inventory_txns_gtmp
4876: WHERE doc_id = l_matl_dtl.batch_id AND
4877: doc_type = l_doc_type AND
4878: material_detail_id = p_line_id AND
4879: transaction_no <> 2 AND

Line 4890: FROM gme_inventory_txns_gtmp

4886:
4887: l_pos := 6;
4888: SELECT trans_id
4889: INTO x_def_lot_id
4890: FROM gme_inventory_txns_gtmp
4891: WHERE doc_id = l_matl_dtl.batch_id AND
4892: doc_type = l_doc_type AND
4893: material_detail_id = p_line_id AND
4894: transaction_no <> 2 AND

Line 4975: p_table_name => 'gme_inventory_txns_gtmp',

4971: EXCEPTION
4972: WHEN OTHERS THEN
4973: x_return_status := 'D';
4974: insert_message (
4975: p_table_name => 'gme_inventory_txns_gtmp',
4976: p_procedure_name => 'get_default_lot',
4977: p_parameters => 'line_id= ' || p_line_id,
4978: p_message => SQLERRM || ' with pos = ' || l_pos,
4979: p_error_type => x_return_status