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.BOMPVALB dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 58: from bom_bill_of_mtls_interface

54: assembly_item_id AII, common_bill_sequence_id CBSI,
55: common_assembly_item_id CAII, assembly_type AST,
56: common_organization_id COI,
57: alternate_bom_designator ABD, transaction_id TI
58: from bom_bill_of_mtls_interface
59: where process_flag = 2
60: and rownum < 500;
61:
62: ret_code NUMBER;

Line 92: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

88: prog_id => prog_id,
89: req_id => request_id,
90: trans_id => c1rec.TI,
91: error_text => err_text,
92: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
93: msg_name => 'BOM_INVALID_ORG_ID',
94: err_text => err_text);
95: update bom_bill_of_mtls_interface set
96: process_flag = 3

Line 95: update bom_bill_of_mtls_interface set

91: error_text => err_text,
92: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
93: msg_name => 'BOM_INVALID_ORG_ID',
94: err_text => err_text);
95: update bom_bill_of_mtls_interface set
96: process_flag = 3
97: where transaction_id = c1rec.TI;
98:
99: if (ret_code <> 0) then

Line 124: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

120: prog_id => prog_id,
121: req_id => request_id,
122: trans_id => c1rec.TI,
123: error_text => err_text,
124: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
125: msg_name => 'BOM_INVALID_ALTERNATE',
126: err_text => err_text);
127: update bom_bill_of_mtls_interface set
128: process_flag = 3

Line 127: update bom_bill_of_mtls_interface set

123: error_text => err_text,
124: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
125: msg_name => 'BOM_INVALID_ALTERNATE',
126: err_text => err_text);
127: update bom_bill_of_mtls_interface set
128: process_flag = 3
129: where transaction_id = c1rec.TI;
130:
131: if (ret_code <> 0) then

Line 153: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

149: prog_id => prog_id,
150: req_id => request_id,
151: trans_id => c1rec.TI,
152: error_text => err_text,
153: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
154: msg_name => 'BOM_ASSEMBLY_ITEM_INVALID',
155: err_text => err_text);
156: update bom_bill_of_mtls_interface set
157: process_flag = 3

Line 156: update bom_bill_of_mtls_interface set

152: error_text => err_text,
153: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
154: msg_name => 'BOM_ASSEMBLY_ITEM_INVALID',
155: err_text => err_text);
156: update bom_bill_of_mtls_interface set
157: process_flag = 3
158: where transaction_id = c1rec.TI;
159:
160: if (ret_code <> 0) then

Line 177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

173: prog_id => prog_id,
174: req_id => request_id,
175: trans_id => c1rec.TI,
176: error_text => err_text,
177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
178: msg_name => 'BOM_ASSEMBLY_TYPE_INVALID',
179: err_text => err_text);
180: update bom_bill_of_mtls_interface set
181: process_flag = 3

Line 180: update bom_bill_of_mtls_interface set

176: error_text => err_text,
177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
178: msg_name => 'BOM_ASSEMBLY_TYPE_INVALID',
179: err_text => err_text);
180: update bom_bill_of_mtls_interface set
181: process_flag = 3
182: where transaction_id = c1rec.TI;
183:
184: if (ret_code <> 0) then

Line 205: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

201: prog_id => prog_id,
202: req_id => request_id,
203: trans_id => c1rec.TI,
204: error_text => err_text,
205: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
206: msg_name => 'BOM_DUPLICATE_BILL',
207: err_text => err_text);
208: update bom_bill_of_mtls_interface set
209: process_flag = 3

Line 208: update bom_bill_of_mtls_interface set

204: error_text => err_text,
205: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
206: msg_name => 'BOM_DUPLICATE_BILL',
207: err_text => err_text);
208: update bom_bill_of_mtls_interface set
209: process_flag = 3
210: where transaction_id = c1rec.TI;
211:
212: if (ret_code <> 0) then

Line 239: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

235: prog_id => prog_id,
236: req_id => request_id,
237: trans_id => c1rec.TI,
238: error_text => err_text,
239: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
240: msg_name => 'BOM_BILL_VALIDATION_ERR',
241: err_text => err_text);
242: update bom_bill_of_mtls_interface set
243: process_flag = 3

Line 242: update bom_bill_of_mtls_interface set

238: error_text => err_text,
239: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
240: msg_name => 'BOM_BILL_VALIDATION_ERR',
241: err_text => err_text);
242: update bom_bill_of_mtls_interface set
243: process_flag = 3
244: where transaction_id = c1rec.TI;
245:
246: if (ret_code <> 0) then

Line 268: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

264: prog_id => prog_id,
265: req_id => request_id,
266: trans_id => c1rec.TI,
267: error_text => err_text,
268: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
269: msg_name => 'BOM_ASSY_TYPE_ERR',
270: err_text => err_text);
271: update bom_bill_of_mtls_interface set
272: process_flag = 3

Line 271: update bom_bill_of_mtls_interface set

267: error_text => err_text,
268: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
269: msg_name => 'BOM_ASSY_TYPE_ERR',
270: err_text => err_text);
271: update bom_bill_of_mtls_interface set
272: process_flag = 3
273: where transaction_id = c1rec.TI;
274:
275: if (ret_code <> 0) then

Line 299: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

295: prog_id => prog_id,
296: req_id => request_id,
297: trans_id => c1rec.TI,
298: error_text => err_text,
299: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
300: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
301: err_text => err_text);
302: update bom_bill_of_mtls_interface set
303: process_flag = 3

Line 302: update bom_bill_of_mtls_interface set

298: error_text => err_text,
299: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
300: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
301: err_text => err_text);
302: update bom_bill_of_mtls_interface set
303: process_flag = 3
304: where transaction_id = c1rec.TI;
305:
306: if (ret_code <> 0) then

Line 333: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

329: prog_id => prog_id,
330: req_id => request_id,
331: trans_id => c1rec.TI,
332: error_text => err_text,
333: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
334: msg_name => 'BOM_COMMON_BOM_ERROR',
335: err_text => err_text);
336: update bom_bill_of_mtls_interface set
337: process_flag = 3

Line 336: update bom_bill_of_mtls_interface set

332: error_text => err_text,
333: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
334: msg_name => 'BOM_COMMON_BOM_ERROR',
335: err_text => err_text);
336: update bom_bill_of_mtls_interface set
337: process_flag = 3
338: where transaction_id = c1rec.TI;
339:
340: if (ret_code <> 0) then

Line 348: update bom_bill_of_mtls_interface

344: end if;
345: end if;
346:
347: stmt_num := 10;
348: update bom_bill_of_mtls_interface
349: set process_flag = 4
350: where transaction_id = c1rec.TI;
351:
352: <>

Line 472: from bom_bill_of_mtls_interface

468: ** check in interface table
469: */
470: select count(*)
471: into cnt
472: from bom_bill_of_mtls_interface
473: where bill_sequence_id = bom_seq_id
474: and process_flag = 4;
475:
476: if (cnt = 0) then

Line 561: from bom_bill_of_mtls_interface

557:
558: begin
559: select bill_sequence_id
560: into cnt
561: from bom_bill_of_mtls_interface
562: where organization_id = org_id
563: and assembly_item_id = assy_id
564: and nvl(alternate_bom_designator, 'NONE') =
565: nvl(alt_desg, 'NONE')

Line 609: from bom_bill_of_mtls_interface

605:
606: begin
607: select bill_sequence_id
608: into cnt
609: from bom_bill_of_mtls_interface
610: where organization_id = org_id
611: and assembly_item_id = assy_id
612: and alternate_bom_designator is null
613: and ((assy_type = 2)

Line 798: from bom_bill_of_mtls_interface

794: end;
795:
796: select bill_sequence_id
797: into cnt
798: from bom_bill_of_mtls_interface
799: where bill_sequence_id = cmn_bom_id
800: and assembly_item_id = cmn_item_id
801: and organization_id = cmn_org_id
802: and nvl(alternate_bom_designator, 'NONE') =

Line 1287: from bom_bill_of_mtls_interface

1283: end;
1284: begin
1285: select 'Is pointing to a common'
1286: into dummy
1287: from bom_bill_of_mtls_interface
1288: where bill_sequence_id = c1rec.BSI
1289: and process_flag = 4
1290: and common_bill_sequence_id <> c1rec.BSI;
1291:

Line 1329: from bom_bill_of_mtls_interface

1325: from bom_bill_of_materials
1326: where bill_sequence_id = c1rec.BSI;
1327: Cursor CheckInterface is
1328: select assembly_type
1329: from bom_bill_of_mtls_interface
1330: where bill_sequence_id = c1rec.BSI
1331: and process_flag = 4;
1332: begin
1333: eng_bill := null;

Line 2683: bom_bill_of_mtls_interface bbom

2679: select bbom.organization_id,
2680: bbom.assembly_item_id, bic.bom_item_type
2681: into org_id_dummy, assy_id_dummy, comp_type
2682: from bom_inventory_comps_interface bic,
2683: bom_bill_of_mtls_interface bbom
2684: where component_sequence_id = c1rec.CSI
2685: and bic.process_flag = 4
2686: and bbom.process_flag = 4
2687: and bbom.bill_sequence_id = bic.bill_sequence_id;

Line 3080: bom_bill_of_mtls_interface bbom

3076: bic.bom_item_type
3077: into assy_id_dummy, org_id_dummy,assy_type_dummy,
3078: comp_id_dummy, comp_type
3079: from bom_inventory_comps_interface bic,
3080: bom_bill_of_mtls_interface bbom
3081: where component_sequence_id = c1rec.CSI
3082: and bic.process_flag = 4
3083: and bbom.process_flag = 4
3084: and bbom.bill_sequence_id = bic.bill_sequence_id;

Line 3615: from bom_bill_of_mtls_interface

3611:
3612: if (dummy_bill = 0) then
3613: select count(*)
3614: into dummy_bill
3615: from bom_bill_of_mtls_interface
3616: where process_flag = 4
3617: and organization_id = c0rec.OI
3618: and assembly_item_id = c0rec.AII;
3619: