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.BOM_BILL_API dependencies on BOM_BILL_OF_MATERIALS

Line 444: FROM bom_bill_of_materials

440: ELSE
441: BEGIN
442: SELECT bill_sequence_id
443: INTO c1rec.CBSI
444: FROM bom_bill_of_materials
445: WHERE organization_id = nvl(c1rec.COI, c1rec.OI)
446: AND assembly_item_id = c1rec.CAII
447: AND nvl(alternate_bom_designator, 'NONE') =
448: nvl(c1rec.ABD, 'NONE');

Line 497: FROM bom_bill_of_materials

493: stmt_num := 10;
494: BEGIN
495: SELECT assembly_item_id, organization_id
496: INTO c1rec.CAII, c1rec.COI
497: FROM bom_bill_of_materials
498: WHERE bill_sequence_id = c1rec.CBSI;
499: GOTO skip_interface1;
500: EXCEPTION
501: WHEN no_data_found THEN

Line 704: FROM bom_bill_of_materials bom,

700: BEGIN
701: SELECT bom.bill_sequence_id, bom.assembly_type,
702: msi.bom_item_type
703: INTO c2rec.BSI, c2rec.AST, x_bom_item_type
704: FROM bom_bill_of_materials bom,
705: mtl_system_items msi
706: WHERE bom.organization_id = c2rec.OI
707: AND bom.assembly_item_id = c2rec.AII
708: AND nvl(bom.alternate_bom_designator, 'NONE') =

Line 746: FROM bom_bill_of_materials bom,

742: bom.alternate_bom_designator, bom.assembly_type,
743: msi.bom_item_type
744: INTO c2rec.AII, c2rec.OI, c2rec.ABD, c2rec.AST,
745: x_bom_item_type
746: FROM bom_bill_of_materials bom,
747: mtl_system_items msi
748: WHERE bom.bill_sequence_id = c2rec.BSI
749: AND msi.organization_id = bom.organization_id
750: AND msi.inventory_item_id = bom.assembly_item_id;

Line 891: FROM bom_bill_of_materials

887: stmt_num :=21;
888: BEGIN
889: SELECT bill_sequence_id
890: INTO c2rec.CBSI
891: FROM bom_bill_of_materials
892: WHERE organization_id = nvl(c2rec.COI, c2rec.OI)
893: AND assembly_item_id = c2rec.CAII
894: AND nvl(alternate_bom_designator, 'NONE') =
895: nvl(c2rec.ABD, 'NONE');

Line 946: FROM bom_bill_of_materials

942: stmt_num := 23;
943: BEGIN
944: SELECT assembly_item_id, organization_id
945: INTO c2rec.CAII, c2rec.COI
946: FROM bom_bill_of_materials
947: WHERE bill_sequence_id = c2rec.CBSI;
948: GOTO skip_interface2;
949: EXCEPTION
950: WHEN no_data_found THEN

Line 1087: FROM bom_bill_of_materials

1083: stmt_num := 1;
1084: BEGIN
1085: SELECT bill_sequence_id
1086: INTO cnt
1087: FROM bom_bill_of_materials
1088: WHERE bill_sequence_id = bom_seq_id;
1089:
1090: IF (mode_type = 2) THEN
1091: RETURN(0);

Line 1184: FROM bom_bill_of_materials

1180: stmt_num := 1;
1181: BEGIN
1182: SELECT 1
1183: INTO cnt
1184: FROM bom_bill_of_materials
1185: WHERE organization_id = org_id
1186: AND assembly_item_id = assy_id
1187: AND nvl(alternate_bom_designator, 'NONE') =
1188: nvl(alt_desg, 'NONE');

Line 1231: FROM bom_bill_of_materials

1227: IF (alt_desg is not null) THEN
1228: BEGIN
1229: SELECT 1
1230: INTO cnt
1231: FROM bom_bill_of_materials
1232: WHERE organization_id = org_id
1233: AND assembly_item_id = assy_id
1234: AND alternate_bom_designator is null
1235: AND ((assy_type = 2)

Line 1356: FROM bom_bill_of_materials

1352: stmt_num := 2;
1353: BEGIN
1354: SELECT bill_sequence_id
1355: INTO cnt
1356: FROM bom_bill_of_materials
1357: WHERE bill_sequence_id = cmn_bom_id
1358: AND assembly_item_id = cmn_item_id
1359: AND organization_id = cmn_org_id
1360: AND nvl(alternate_bom_designator, 'NONE') = nvl(alt_desg, 'NONE')

Line 2095: FROM bom_bill_of_materials bom,

2091: X_program_update_date,
2092: X_assembly_type, X_common_bill_sequence_id,
2093: X_common_organization_id, X_next_explode_date,
2094: x_bom_item_type
2095: FROM bom_bill_of_materials bom,
2096: mtl_system_items msi
2097: WHERE bill_sequence_id = c2rec.BSI
2098: AND msi.organization_id = bom.organization_id
2099: AND msi.inventory_item_id = bom.assembly_item_id;

Line 2454: BOM_BILL_OF_MATERIALS.

2450: Transact_Bill
2451: DESCRIPTION
2452: Insert, update and delete bill data from the interface
2453: table, BOM_BILL_OF_MTLS_INTERFACE, into the production table,
2454: BOM_BILL_OF_MATERIALS.
2455: REQUIRES
2456: prog_appid Program application id
2457: prog_id Program id
2458: req_id Request id

Line 2462: BOM_BILL_OF_MATERIALS

2458: req_id Request id
2459: user_id User id
2460: login_id Login id
2461: MODIFIES
2462: BOM_BILL_OF_MATERIALS
2463: BOM_BILL_OF_MTLS_INTERFACE
2464: RETURNS
2465: 0 if successful
2466: SQLCODE if error

Line 2526: INSERT INTO bom_bill_of_materials(

2522: ** Insert bills
2523: */
2524: stmt_num := 1;
2525: LOOP
2526: INSERT INTO bom_bill_of_materials(
2527: assembly_item_id,
2528: organization_id,
2529: alternate_bom_designator,
2530: last_update_date,

Line 2612: FROM bom_bill_of_materials bom

2608: SET process_flag = 7
2609: WHERE process_flag = 4
2610: AND transaction_type = G_Insert
2611: AND exists (SELECT null
2612: FROM bom_bill_of_materials bom
2613: WHERE bom.bill_sequence_id = bi.bill_sequence_id);
2614: stmt_num := 3;
2615: COMMIT;
2616:

Line 2627: UPDATE bom_bill_of_materials

2623: WHILE continue_loop LOOP
2624: commit_cnt := 0;
2625: FOR c1rec IN c1 LOOP
2626: commit_cnt := commit_cnt + 1;
2627: UPDATE bom_bill_of_materials
2628: SET last_update_date = c1rec.LUD,
2629: last_updated_by = c1rec.LUB,
2630: last_update_login = c1rec.LUL,
2631: common_assembly_item_id = c1rec.CAII,