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_SUB_COMPS_INTERFACE

Line 38: BOM_SUB_COMPS_INTERFACE

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
40: RETURNS
41: 0 if successful
42: SQLCODE if unsuccessful

Line 109: update bom_sub_comps_interface ori

105: end loop;
106:
107: stmt_num := 5;
108: loop
109: update bom_sub_comps_interface ori
110: set organization_id = (select organization_id from
111: mtl_parameters a
112: where a.organization_code = ori.organization_code)
113: where process_flag = 1

Line 1364: BOM_SUB_COMPS_INTERFACE

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
1366: RETURNS
1367: 0 if successful
1368: SQLCODE if unsuccessful

Line 1398: From bom_sub_comps_interface bsc

1394: and brd.assembly_item_number = item_number
1395: and brd.bill_sequence_id is null;
1396: Cursor GetSubComps is
1397: Select bsc.rowid row_id
1398: From bom_sub_comps_interface bsc
1399: where bsc.process_flag = 1
1400: and bsc.assembly_item_id is null
1401: and bsc.organization_id = org_id
1402: and bsc.assembly_item_number = item_number

Line 1428: update bom_sub_comps_interface ori

1424: end if; -- commit every 500 rows
1425: end loop;
1426:
1427: For X_Substitute in GetSubComps loop
1428: update bom_sub_comps_interface ori
1429: set ori.assembly_item_id = item_id
1430: where ori.rowid = X_Substitute.row_id;
1431: If mod(GetSubComps%rowcount, 500) = 0 then
1432: commit;

Line 1506: update bom_sub_comps_interface set

1502: commit;
1503: end loop;
1504:
1505: loop
1506: update bom_sub_comps_interface set
1507: bill_sequence_id = bom_id
1508: where process_flag = 1
1509: and organization_id = org_id
1510: and assembly_item_id = assy_id

Line 1582: update bom_sub_comps_interface set

1578:
1579:
1580: stmt_num := 2;
1581: loop
1582: update bom_sub_comps_interface set
1583: component_sequence_id = cmp_seq_id
1584: where process_flag = 1
1585: and organization_id = org_id
1586: and assembly_item_id = assy_id

Line 2084: BOM_SUB_COMPS_INTERFACE

2080: for existing records
2081: REQUIRES
2082: err_text out buffer to return error message
2083: MODIFIES
2084: BOM_SUB_COMPS_INTERFACE
2085: MTL_INTERFACE_ERRORS
2086: RETURNS
2087: 0 if successful
2088: SQLCODE if unsuccessful

Line 2114: from bom_sub_comps_interface

2110:
2111: CURSOR c0 is
2112: select organization_id OI, substitute_comp_number SCN,
2113: substitute_component_id SCI, transaction_id TI
2114: from bom_sub_comps_interface
2115: where process_flag = 1
2116: and substitute_component_id is null
2117: and (all_org = 1
2118: or

Line 2131: from bom_sub_comps_interface

2127: assembly_item_number AIN, alternate_bom_designator ABD,
2128: component_item_id CII, component_item_number CIN,
2129: operation_seq_num OSN,
2130: to_char(effectivity_date,'YYYY/MM/DD HH24:MI') ED
2131: from bom_sub_comps_interface
2132: where process_flag = 1
2133: and component_sequence_id is null
2134: and (all_org = 1
2135: or

Line 2143: from bom_sub_comps_interface

2139:
2140: CURSOR c2 is
2141: select transaction_id TI, organization_id OI,
2142: component_sequence_id CSI, substitute_item_quantity SIQ
2143: from bom_sub_comps_interface
2144: where process_flag = 1
2145: and component_sequence_id is not null
2146: and (all_org = 1
2147: or

Line 2154: from bom_sub_comps_interface

2150: and rownum < 500;
2151:
2152: CURSOR c3 is
2153: select component_sequence_id CSI
2154: from bom_sub_comps_interface
2155: where process_flag = 99
2156: and (all_org = 1
2157: or
2158: (all_org = 2 and organization_id = org_id)

Line 2167: insert into bom_sub_comps_interface (

2163: BEGIN
2164: /*
2165: ** first load all rows from components interface into sub comps interface
2166: */
2167: insert into bom_sub_comps_interface (
2168: SUBSTITUTE_COMPONENT_ID,
2169: SUBSTITUTE_COMP_NUMBER,
2170: ORGANIZATION_ID,
2171: LAST_UPDATE_DATE,

Line 2210: update bom_sub_comps_interface

2206: /*
2207: ** assign transaction ids for every row
2208: */
2209: loop
2210: update bom_sub_comps_interface
2211: set transaction_id = mtl_system_items_interface_s.nextval
2212: where transaction_id is null
2213: and process_flag = 1
2214: and rownum < 500;

Line 2243: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2239: prog_id => prog_id,
2240: req_id => req_id,
2241: trans_id => c0rec.TI,
2242: error_text => err_text,
2243: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2244: msg_name => 'BOM_SUB_COMP_MISSING',
2245: err_text => err_text);
2246: update bom_sub_comps_interface set
2247: process_flag = 3

Line 2246: update bom_sub_comps_interface set

2242: error_text => err_text,
2243: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2244: msg_name => 'BOM_SUB_COMP_MISSING',
2245: err_text => err_text);
2246: update bom_sub_comps_interface set
2247: process_flag = 3
2248: where transaction_id = c0rec.TI;
2249:
2250: if (ret_code <> 0) then

Line 2254: update bom_sub_comps_interface

2250: if (ret_code <> 0) then
2251: return(ret_code);
2252: end if;
2253: else
2254: update bom_sub_comps_interface
2255: set substitute_component_id = c0rec.SCI
2256: where transaction_id = c0rec.TI;
2257: end if;
2258:

Line 2285: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2281: prog_id => prog_id,
2282: req_id => req_id,
2283: trans_id => c1rec.TI,
2284: error_text => err_text,
2285: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2286: msg_name => 'BOM_ORG_ID_MISSING',
2287: err_text => err_text);
2288: update bom_sub_comps_interface set
2289: process_flag = 3

Line 2288: update bom_sub_comps_interface set

2284: error_text => err_text,
2285: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2286: msg_name => 'BOM_ORG_ID_MISSING',
2287: err_text => err_text);
2288: update bom_sub_comps_interface set
2289: process_flag = 3
2290: where transaction_id = c1rec.TI;
2291:
2292: if (ret_code <> 0) then

Line 2319: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2315: prog_id => prog_id,
2316: req_id => req_id,
2317: trans_id => c1rec.TI,
2318: error_text => err_text,
2319: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2320: msg_name => 'BOM_ASSY_ITEM_MISSING',
2321: err_text => err_text);
2322: update bom_sub_comps_interface set
2323: process_flag = 3

Line 2322: update bom_sub_comps_interface set

2318: error_text => err_text,
2319: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2320: msg_name => 'BOM_ASSY_ITEM_MISSING',
2321: err_text => err_text);
2322: update bom_sub_comps_interface set
2323: process_flag = 3
2324: where transaction_id = c1rec.TI;
2325:
2326: if (ret_code <> 0) then

Line 2354: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2350: prog_id => prog_id,
2351: req_id => req_id,
2352: trans_id => c1rec.TI,
2353: error_text => err_text,
2354: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2355: msg_name => 'BOM_BILL_SEQ_MISSING',
2356: err_text => err_text);
2357: update bom_sub_comps_interface set
2358: process_flag = 3

Line 2357: update bom_sub_comps_interface set

2353: error_text => err_text,
2354: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2355: msg_name => 'BOM_BILL_SEQ_MISSING',
2356: err_text => err_text);
2357: update bom_sub_comps_interface set
2358: process_flag = 3
2359: where transaction_id = c1rec.TI;
2360:
2361: if (ret_code <> 0) then

Line 2390: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2386: prog_id => prog_id,
2387: req_id => req_id,
2388: trans_id => c1rec.TI,
2389: error_text => err_text,
2390: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2391: msg_name => 'BOM_COMP_ID_MISSING',
2392: err_text => err_text);
2393: update bom_sub_comps_interface set
2394: process_flag = 3

Line 2393: update bom_sub_comps_interface set

2389: error_text => err_text,
2390: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2391: msg_name => 'BOM_COMP_ID_MISSING',
2392: err_text => err_text);
2393: update bom_sub_comps_interface set
2394: process_flag = 3
2395: where transaction_id = c1rec.TI;
2396:
2397: if (ret_code <> 0) then

Line 2424: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2420: prog_id => prog_id,
2421: req_id => req_id,
2422: trans_id => c1rec.TI,
2423: error_text => err_text,
2424: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2425: msg_name => 'BOM_COMP_SEQ_MISSING',
2426: err_text => err_text);
2427: update bom_sub_comps_interface set
2428: process_flag = 3

Line 2427: update bom_sub_comps_interface set

2423: error_text => err_text,
2424: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2425: msg_name => 'BOM_COMP_SEQ_MISSING',
2426: err_text => err_text);
2427: update bom_sub_comps_interface set
2428: process_flag = 3
2429: where transaction_id = c1rec.TI;
2430:
2431: if (ret_code <> 0) then

Line 2437: update bom_sub_comps_interface

2433: end if;
2434: goto continue_loop;
2435: end if;
2436:
2437: update bom_sub_comps_interface
2438: set component_sequence_id = c1rec.CSI,
2439: assembly_item_id = c1rec.AII,
2440: component_item_id = c1rec.CII,
2441: bill_sequence_id = c1rec.BSI

Line 2479: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

2475: prog_id => prog_id,
2476: req_id => req_id,
2477: trans_id => c2rec.TI,
2478: error_text => err_text,
2479: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2480: msg_name => 'BOM_SUB_COMP_QTY_MISSING',
2481: err_text => err_text);
2482: update bom_sub_comps_interface set
2483: process_flag = 3

Line 2482: update bom_sub_comps_interface set

2478: error_text => err_text,
2479: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
2480: msg_name => 'BOM_SUB_COMP_QTY_MISSING',
2481: err_text => err_text);
2482: update bom_sub_comps_interface set
2483: process_flag = 3
2484: where transaction_id = c2rec.TI;
2485:
2486: if (ret_code <> 0) then

Line 2493: update bom_sub_comps_interface

2489: goto continue_loop2;
2490: end if;
2491: end if;
2492:
2493: update bom_sub_comps_interface
2494: set process_flag = 99,
2495: substitute_item_quantity = nvl(c2rec.SIQ,substitute_item_quantity),
2496: last_update_date = nvl(last_update_date,sysdate),
2497: last_updated_by = nvl(last_updated_by,user_id),

Line 2524: from bom_sub_comps_interface

2520: ** for set processing
2521: */
2522: select count(distinct component_sequence_id)
2523: into total_recs
2524: from bom_sub_comps_interface
2525: where process_flag = 99;
2526:
2527: continue_loop := TRUE;
2528: commit_cnt := 0;

Line 2537: update bom_sub_comps_interface

2533: select mtl_system_items_interface_s.nextval
2534: into dummy_txn
2535: from sys.dual;
2536:
2537: update bom_sub_comps_interface
2538: set transaction_id = dummy_txn,
2539: process_flag = 2
2540: where component_sequence_id = c3rec.CSI
2541: and process_flag = 99;