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

Line 35: BOM_BILL_OF_MTLS_INTERFACE

31:
32: REQUIRES
33: err_text out buffer to return error message
34: MODIFIES
35: BOM_BILL_OF_MTLS_INTERFACE
36: BOM_INVENTORY_COMPS_INTERFACE
37: BOM_REF_DESGS_INTERFACE
38: BOM_SUB_COMPS_INTERFACE
39: MTL_INTERFACE_ERRORS

Line 55: update bom_bill_of_mtls_interface ori

51: stmt_num NUMBER;
52: BEGIN
53: stmt_num := 1;
54: loop
55: update bom_bill_of_mtls_interface ori
56: set organization_id = (select organization_id from
57: mtl_parameters a
58: where a.organization_code = ori.organization_code)
59: where process_flag = 1

Line 371: from bom_bill_of_mtls_interface

367: alternate_bom_designator ABD, transaction_id TI,
368: bill_sequence_id BSI, common_bill_sequence_id CBSI,
369: revision R, last_update_date LUD, last_updated_by LUB,
370: creation_date CD, created_by CB, last_update_login LUL
371: from bom_bill_of_mtls_interface
372: where process_flag = 1
373: and (all_org = 1
374: or
375: (all_org = 2 and organization_id = org_id)

Line 385: from bom_bill_of_mtls_interface

381: assembly_item_id AII, common_assembly_item_id CAAI,
382: common_assembly_item_id CAID, organization_id OI,
383: alternate_bom_designator ABD, common_organization_id COI,
384: bill_Sequence_id BSI
385: from bom_bill_of_mtls_interface
386: where process_flag = 99
387: and (all_org = 1
388: or
389: (all_org = 2 and organization_id = org_id)

Line 406: update bom_bill_of_mtls_interface ori

402: ** assign transaction ids for every row first
403: */
404: stmt_num := 1;
405: loop
406: update bom_bill_of_mtls_interface ori
407: set transaction_id = mtl_system_items_interface_s.nextval,
408: bill_sequence_id = nvl(bill_sequence_id,
409: bom_inventory_components_s.nextval)
410: where transaction_id is null

Line 433: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

429: prog_id => prog_id,
430: req_id => req_id,
431: trans_id => c1rec.TI,
432: error_text => err_text,
433: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
434: msg_name => 'BOM_ORG_ID_MISSING',
435: err_text => err_text);
436: update bom_bill_of_mtls_interface set
437: process_flag = 3

Line 436: update bom_bill_of_mtls_interface set

432: error_text => err_text,
433: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
434: msg_name => 'BOM_ORG_ID_MISSING',
435: err_text => err_text);
436: update bom_bill_of_mtls_interface set
437: process_flag = 3
438: where transaction_id = c1rec.TI;
439:
440: goto continue_loop;

Line 465: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

461: prog_id => prog_id,
462: req_id => req_id,
463: trans_id => c1rec.TI,
464: error_text => err_text,
465: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
466: msg_name => 'BOM_ASSY_ITEM_MISSING',
467: err_text => err_text);
468: update bom_bill_of_mtls_interface set
469: process_flag = 3

Line 468: update bom_bill_of_mtls_interface set

464: error_text => err_text,
465: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
466: msg_name => 'BOM_ASSY_ITEM_MISSING',
467: err_text => err_text);
468: update bom_bill_of_mtls_interface set
469: process_flag = 3
470: where transaction_id = c1rec.TI;
471:
472: if (ret_code <> 0) then

Line 499: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

495: prog_id => prog_id,
496: req_id => req_id,
497: trans_id => c1rec.TI,
498: error_text => err_text,
499: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
500: msg_name => 'BOM_COMMON_ORG_MISSING',
501: err_text => err_text);
502: update bom_bill_of_mtls_interface set
503: process_flag = 3

Line 502: update bom_bill_of_mtls_interface set

498: error_text => err_text,
499: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
500: msg_name => 'BOM_COMMON_ORG_MISSING',
501: err_text => err_text);
502: update bom_bill_of_mtls_interface set
503: process_flag = 3
504: where transaction_id = c1rec.TI;
505:
506: if (ret_code <> 0) then

Line 539: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

535: prog_id => prog_id,
536: req_id => req_id,
537: trans_id => c1rec.TI,
538: error_text => err_text,
539: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
540: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
541: err_text => err_text);
542: update bom_bill_of_mtls_interface set
543: process_flag = 3

Line 542: update bom_bill_of_mtls_interface set

538: error_text => err_text,
539: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
540: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
541: err_text => err_text);
542: update bom_bill_of_mtls_interface set
543: process_flag = 3
544: where transaction_id = c1rec.TI;
545:
546: if (ret_code <> 0) then

Line 602: update bom_bill_of_mtls_interface

598: end if;
599: end if;
600:
601: stmt_num := 7;
602: update bom_bill_of_mtls_interface
603: set organization_id = nvl(organization_id, c1rec.OI),
604: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
605: common_organization_id = nvl(common_organization_id, c1rec.COI),
606: common_assembly_item_id = nvl(common_assembly_item_id, c1rec.CAII),

Line 697: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

693: prog_id => prog_id,
694: req_id => req_id,
695: trans_id => c2rec.TI,
696: error_text => err_text,
697: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
698: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
699: err_text => err_text);
700: proc_flag := 3;
701: end if;

Line 720: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

716: prog_id => prog_id,
717: req_id => req_id,
718: trans_id => c2rec.TI,
719: error_text => err_text,
720: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
721: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
722: err_text => err_text);
723: proc_flag := 3;
724: end if;

Line 732: update bom_bill_of_mtls_interface set

728: assy_id := NULL;
729: end if;
730: stmt_num := 11;
731:
732: update bom_bill_of_mtls_interface set
733: process_flag = proc_flag,
734: common_bill_sequence_id = c2rec.CBSI,
735: common_organization_id = c_org_id,
736: common_assembly_item_id = assy_id

Line 1194: from bom_bill_of_mtls_interface

1190: END;
1191:
1192: select bill_sequence_id
1193: into bill_seq_id
1194: from bom_bill_of_mtls_interface
1195: where organization_id = org_id
1196: and assembly_item_id = item_id
1197: and nvl(alternate_bom_designator, 'NONE') =
1198: nvl(alt_desg, 'NONE')

Line 1334: from bom_bill_of_mtls_interface

1330: END;
1331:
1332: select assembly_item_id, organization_id, alternate_bom_designator
1333: into item_id, org_id, alt_desg
1334: from bom_bill_of_mtls_interface
1335: where bill_sequence_id = bill_seq_id
1336: and process_flag <> 3 and process_flag <> 7
1337: and rownum = 1;
1338:

Line 1361: BOM_BILL_OF_MTLS_INTERFACE

1357:
1358: REQUIRES
1359: err_text out buffer to return error message
1360: MODIFIES
1361: BOM_BILL_OF_MTLS_INTERFACE
1362: BOM_INVENTORY_COMPS_INTERFACE
1363: BOM_REF_DESGS_INTERFACE
1364: BOM_SUB_COMPS_INTERFACE
1365: MTL_INTERFACE_ERRORS