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 PM_MATL_DTL_BAK

Line 53: -- Corrected reference of pm_matl_dt to pm_matl_dtl_bak

49: -- Moved 1 line of code, so that it will print the correct
50: -- message.
51: -- Also changed l_tran_reverse.trans_id to l_tran_row.trans_id
52: -- Shrikant Nene - 02/10/2003 B2792583
53: -- Corrected reference of pm_matl_dt to pm_matl_dtl_bak
54: -- in procedure renumber_duplicate_line_no.
55: -- Since it was looking at the original table, this procedure
56: -- did not find anything.
57: -- Antonia Newbury - 2/26/2003 Added fixes which came out of 4.1

Line 205: UPDATE pm_matl_dtl_bak

201: );
202:
203: l_pos := 3;
204:
205: UPDATE pm_matl_dtl_bak
206: SET in_use = 0
207: WHERE in_use IS NULL OR
208: in_use NOT in (0,100);
209:

Line 475: pm_matl_dtl_bak bdtl,

471: SELECT NVL (MAX (rollover_ind), -1)
472: INTO v_actual_cost_ind
473: FROM cm_cmpt_dtl ccd,
474: cm_acst_led acl,
475: pm_matl_dtl_bak bdtl,
476: pm_btch_hdr_bak bhdr
477: WHERE ccd.cmpntcost_id = acl.cmpntcost_id AND
478: ccd.delete_mark = 0 AND
479: acl.source_ind = 0 AND

Line 495: p_table_name => 'cm_cmpt_dtl, cm_acst_led, pm_matl_dtl_bak, pm_btch_hdr_bak',

491: END IF;
492: EXCEPTION
493: WHEN OTHERS THEN
494: insert_message (
495: p_table_name => 'cm_cmpt_dtl, cm_acst_led, pm_matl_dtl_bak, pm_btch_hdr_bak',
496: p_procedure_name => 'get_actual_cost_ind',
497: p_parameters => p_batch_id,
498: p_message => SQLERRM || ' with pos = ' || l_pos,
499: p_error_type => 'D'

Line 959: v_line_type pm_matl_dtl_bak.line_type%TYPE;

955: )
956: RETURN NUMBER IS
957: v_batch_status NUMBER;
958: v_qty NUMBER;
959: v_line_type pm_matl_dtl_bak.line_type%TYPE;
960: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
961: l_pos NUMBER := 0;
962: BEGIN
963: l_pos := 1;

Line 987: FROM ic_tran_pnd i, pm_matl_dtl_bak l

983: 0
984: )
985: )
986: INTO v_qty
987: FROM ic_tran_pnd i, pm_matl_dtl_bak l
988: WHERE doc_id = p_batch_id AND
989: doc_type IN ('PROD', 'FPO') AND
990: i.line_id = p_line_id AND
991: i.line_id = l.line_id AND

Line 1004: FROM pm_matl_dtl_bak

1000:
1001: l_pos := 7;
1002: SELECT line_type
1003: INTO v_line_type
1004: FROM pm_matl_dtl_bak
1005: WHERE line_id = p_line_id;
1006: l_pos := 8;
1007:
1008: IF v_line_type = -1 AND

Line 1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;

1040: v_plant_code pm_btch_hdr_bak.plant_code%TYPE;
1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;
1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
1043: v_qty NUMBER;
1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1045: v_line_no pm_matl_dtl_bak.line_no%TYPE;
1046: l_pos NUMBER := 0;
1047: l_line_type_desc VARCHAR2(80);
1048: l_batch_type_desc VARCHAR2(10);

Line 1045: v_line_no pm_matl_dtl_bak.line_no%TYPE;

1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;
1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
1043: v_qty NUMBER;
1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1045: v_line_no pm_matl_dtl_bak.line_no%TYPE;
1046: l_pos NUMBER := 0;
1047: l_line_type_desc VARCHAR2(80);
1048: l_batch_type_desc VARCHAR2(10);
1049:

Line 1075: FROM ic_tran_pnd i, pm_matl_dtl_bak l

1071: 0
1072: )
1073: )
1074: INTO v_qty
1075: FROM ic_tran_pnd i, pm_matl_dtl_bak l
1076: WHERE doc_id = p_batch_id AND
1077: doc_type IN ('PROD', 'FPO') AND
1078: i.line_id = p_line_id AND
1079: i.line_id = l.line_id AND

Line 1085: FROM pm_matl_dtl_bak

1081: l_pos := 4;
1082:
1083: SELECT line_type, line_no
1084: INTO v_line_type, v_line_no
1085: FROM pm_matl_dtl_bak
1086: WHERE line_id = p_line_id;
1087: l_pos := 5;
1088:
1089: IF v_qty IS NULL THEN

Line 1157: v_line_type pm_matl_dtl_bak.line_type%TYPE;

1153: )
1154: RETURN NUMBER IS
1155: v_batch_status NUMBER;
1156: v_qty NUMBER;
1157: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1158: v_scrap_factor pm_matl_dtl_bak.scrap_factor%TYPE;
1159: v_item_um pm_matl_dtl_bak.item_um%TYPE;
1160: l_pos NUMBER := 0;
1161: BEGIN

Line 1158: v_scrap_factor pm_matl_dtl_bak.scrap_factor%TYPE;

1154: RETURN NUMBER IS
1155: v_batch_status NUMBER;
1156: v_qty NUMBER;
1157: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1158: v_scrap_factor pm_matl_dtl_bak.scrap_factor%TYPE;
1159: v_item_um pm_matl_dtl_bak.item_um%TYPE;
1160: l_pos NUMBER := 0;
1161: BEGIN
1162: l_pos := 1;

Line 1159: v_item_um pm_matl_dtl_bak.item_um%TYPE;

1155: v_batch_status NUMBER;
1156: v_qty NUMBER;
1157: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1158: v_scrap_factor pm_matl_dtl_bak.scrap_factor%TYPE;
1159: v_item_um pm_matl_dtl_bak.item_um%TYPE;
1160: l_pos NUMBER := 0;
1161: BEGIN
1162: l_pos := 1;
1163: SELECT batch_status

Line 1182: FROM pm_matl_dtl_bak

1178: line_type
1179: INTO v_scrap_factor,
1180: v_item_um,
1181: v_line_type
1182: FROM pm_matl_dtl_bak
1183: WHERE line_id = p_line_id;
1184: l_pos := 5;
1185:
1186: IF v_batch_status = 3 /* Certified */ OR

Line 1275: FROM pm_btch_hdr_bak h, pm_matl_dtl_bak d

1271: h.batch_type,
1272: h.batch_no,
1273: d.line_no,
1274: d.line_id
1275: FROM pm_btch_hdr_bak h, pm_matl_dtl_bak d
1276: WHERE h.batch_status = 2 AND
1277: d.batch_id = h.batch_id AND
1278: d.line_type IN (-1, 1) AND
1279: d.in_use <

Line 2807: FROM pm_matl_dtl_bak

2803: attribute28,
2804: attribute29,
2805: attribute30,
2806: attribute_category
2807: FROM pm_matl_dtl_bak
2808: WHERE in_use < 100;
2809:
2810: insert_message (
2811: p_table_name => 'gme_material_details',

Line 2823: UPDATE pm_matl_dtl_bak

2819: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2820: RAISE error_detail;
2821: END IF;
2822:
2823: UPDATE pm_matl_dtl_bak
2824: SET in_use = in_use + 100
2825: WHERE in_use < 100;
2826: EXCEPTION
2827: WHEN error_detail THEN

Line 4212: FROM pm_matl_dtl_bak m, pm_btch_hdr_bak b

4208: PROCEDURE split_trans_line (x_return_status OUT NOCOPY VARCHAR2) IS
4209: CURSOR cur_get_materials IS
4210: SELECT b.batch_id,
4211: m.line_id
4212: FROM pm_matl_dtl_bak m, pm_btch_hdr_bak b
4213: WHERE m.in_use < 100 AND -- => only check for lines that were not migrated
4214: b.batch_id = m.batch_id AND
4215: b.batch_status IN (2, 3) AND
4216: b.batch_type = 0

Line 4794: p_line_id IN pm_matl_dtl_bak.line_id%TYPE,

4790: RAISE;
4791: END insert_inv_txns_gtmp;
4792:
4793: PROCEDURE get_default_lot (
4794: p_line_id IN pm_matl_dtl_bak.line_id%TYPE,
4795: x_def_lot_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE,
4796: x_is_plain OUT NOCOPY BOOLEAN,
4797: x_return_status OUT NOCOPY VARCHAR2
4798: ) IS

Line 4799: l_matl_dtl pm_matl_dtl_bak%ROWTYPE;

4795: x_def_lot_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE,
4796: x_is_plain OUT NOCOPY BOOLEAN,
4797: x_return_status OUT NOCOPY VARCHAR2
4798: ) IS
4799: l_matl_dtl pm_matl_dtl_bak%ROWTYPE;
4800: l_item_mst ic_item_mst%ROWTYPE;
4801: l_ic_tran_pnd ic_tran_pnd%ROWTYPE;
4802: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
4803: l_def_lot_found BOOLEAN;

Line 4807: v_line_id pm_matl_dtl_bak.line_id%TYPE,

4803: l_def_lot_found BOOLEAN;
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.

Line 4851: FROM pm_matl_dtl_bak

4847: x_return_status := FND_API.G_RET_STS_SUCCESS;
4848: l_pos := 1;
4849: SELECT *
4850: INTO l_matl_dtl
4851: FROM pm_matl_dtl_bak
4852: WHERE line_id = p_line_id;
4853: l_pos := 2;
4854: SELECT *
4855: INTO l_item_mst

Line 5021: * Changed the reference of pm_matl_dt to pm_matl_dtl_bak *

5017: END deduce_transaction_warehouse;
5018:
5019: /*****************************************************************
5020: * Shrikant Nene - 02/10/2003 B2792583 *
5021: * Changed the reference of pm_matl_dt to pm_matl_dtl_bak *
5022: * in the following procedure *
5023: *****************************************************************/
5024:
5025: PROCEDURE renumber_duplicate_line_no IS

Line 5029: FROM pm_matl_dtl_bak

5025: PROCEDURE renumber_duplicate_line_no IS
5026:
5027: CURSOR cur_get_dup_line_no IS
5028: SELECT batch_id, line_type, line_no
5029: FROM pm_matl_dtl_bak
5030: GROUP BY batch_id, line_type, line_no
5031: HAVING COUNT(1) > 1;
5032:
5033: CURSOR get_matl (v_batch_id NUMBER, v_line_type NUMBER) IS

Line 5035: FROM pm_matl_dtl_bak

5031: HAVING COUNT(1) > 1;
5032:
5033: CURSOR get_matl (v_batch_id NUMBER, v_line_type NUMBER) IS
5034: SELECT line_id
5035: FROM pm_matl_dtl_bak
5036: WHERE batch_id = v_batch_id
5037: AND line_type = v_line_type
5038: ORDER BY line_no asc;
5039:

Line 5079: UPDATE pm_matl_dtl_bak

5075: l_pos := 6;
5076: FOR rec IN get_matl(l_dup_rec.batch_id, l_dup_rec.line_type) LOOP
5077: l_pos := 7;
5078:
5079: UPDATE pm_matl_dtl_bak
5080: SET line_no = l_line_no
5081: WHERE line_id = rec.line_id;
5082:
5083: l_pos := 8;