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.BOMPLDCB dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 175: BOM_INVENTORY_COMPS_INTERFACE b1,

171: b1.component_sequence_id,
172: b1.component_item_id,
173: b1.component_quantity
174: from
175: BOM_INVENTORY_COMPS_INTERFACE b1,
176: BOM_INVENTORY_COMPS_INTERFACE b2,
177: BOM_BILL_OF_MTLS_INTERFACE b3
178: where
179: b1.bill_sequence_id = b2.bill_sequence_id

Line 176: BOM_INVENTORY_COMPS_INTERFACE b2,

172: b1.component_item_id,
173: b1.component_quantity
174: from
175: BOM_INVENTORY_COMPS_INTERFACE b1,
176: BOM_INVENTORY_COMPS_INTERFACE b2,
177: BOM_BILL_OF_MTLS_INTERFACE b3
178: where
179: b1.bill_sequence_id = b2.bill_sequence_id
180: and b1.component_sequence_id <> b2.component_sequence_id

Line 443: ** BOM_INVENTORY_COMPS_INTERFACE table.

439: /*
440: ** First:
441: ** All the chosen option items associated
442: ** with the new configuration items will be loaded into the
443: ** BOM_INVENTORY_COMPS_INTERFACE table.
444: */
445: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
446: stmt_num := 60;
447: insert into BOM_INVENTORY_COMPS_INTERFACE

Line 445: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';

441: ** All the chosen option items associated
442: ** with the new configuration items will be loaded into the
443: ** BOM_INVENTORY_COMPS_INTERFACE table.
444: */
445: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
446: stmt_num := 60;
447: insert into BOM_INVENTORY_COMPS_INTERFACE
448: (
449: OPERATION_SEQ_NUM,

Line 447: insert into BOM_INVENTORY_COMPS_INTERFACE

443: ** BOM_INVENTORY_COMPS_INTERFACE table.
444: */
445: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
446: stmt_num := 60;
447: insert into BOM_INVENTORY_COMPS_INTERFACE
448: (
449: OPERATION_SEQ_NUM,
450: COMPONENT_ITEM_ID,
451: LAST_UPDATE_DATE,

Line 620: ** BOM_INVENTORY_COMPS_INTERFACE table.

616: /*
617: ** Second:
618: ** All the standard component items associated
619: ** with the new configuration items will be loaded into the
620: ** BOM_INVENTORY_COMPS_INTERFACE table.
621: */
622:
623: stmt_num := 70;
624: insert into BOM_INVENTORY_COMPS_INTERFACE

Line 624: insert into BOM_INVENTORY_COMPS_INTERFACE

620: ** BOM_INVENTORY_COMPS_INTERFACE table.
621: */
622:
623: stmt_num := 70;
624: insert into BOM_INVENTORY_COMPS_INTERFACE
625: (
626: OPERATION_SEQ_NUM,
627: COMPONENT_ITEM_ID,
628: LAST_UPDATE_DATE,

Line 787: ** BOM_INVENTORY_COMPS_INTERFACE table.

783: /*
784: ** Third:
785: ** All the chosen option classes associated
786: ** with the new configuration items will be loaded into the
787: ** BOM_INVENTORY_COMPS_INTERFACE table.
788: */
789: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
790: stmt_num := 80;
791: insert into BOM_INVENTORY_COMPS_INTERFACE

Line 789: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';

785: ** All the chosen option classes associated
786: ** with the new configuration items will be loaded into the
787: ** BOM_INVENTORY_COMPS_INTERFACE table.
788: */
789: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
790: stmt_num := 80;
791: insert into BOM_INVENTORY_COMPS_INTERFACE
792: (
793: OPERATION_SEQ_NUM,

Line 791: insert into BOM_INVENTORY_COMPS_INTERFACE

787: ** BOM_INVENTORY_COMPS_INTERFACE table.
788: */
789: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
790: stmt_num := 80;
791: insert into BOM_INVENTORY_COMPS_INTERFACE
792: (
793: OPERATION_SEQ_NUM,
794: COMPONENT_ITEM_ID,
795: LAST_UPDATE_DATE,

Line 962: ** Get the base model row into BOM_INVENTORY_COMPS_INTERFACE

958: and b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')));
959:
960: /*
961: ** Fourth:
962: ** Get the base model row into BOM_INVENTORY_COMPS_INTERFACE
963: */
964: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
965: stmt_num := 90;
966: insert into BOM_INVENTORY_COMPS_INTERFACE

Line 964: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';

960: /*
961: ** Fourth:
962: ** Get the base model row into BOM_INVENTORY_COMPS_INTERFACE
963: */
964: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
965: stmt_num := 90;
966: insert into BOM_INVENTORY_COMPS_INTERFACE
967: (
968: OPERATION_SEQ_NUM,

Line 966: insert into BOM_INVENTORY_COMPS_INTERFACE

962: ** Get the base model row into BOM_INVENTORY_COMPS_INTERFACE
963: */
964: table_name := 'BOM_INVENTORY_COMPS_INTERFACE';
965: stmt_num := 90;
966: insert into BOM_INVENTORY_COMPS_INTERFACE
967: (
968: OPERATION_SEQ_NUM,
969: COMPONENT_ITEM_ID,
970: LAST_UPDATE_DATE,

Line 2043: update BOM_INVENTORY_COMPS_INTERFACE ci

2039: ** set to 1.
2040: */
2041: stmt_num := 175;
2042:
2043: update BOM_INVENTORY_COMPS_INTERFACE ci
2044: set ci.operation_seq_num = 1
2045: where not exists
2046: (select 'op seq exists in config routing'
2047: from

Line 2067: ** If more than one row in the BOM_INVENTORY_COMPS_INTERFACE

2063: where bi2.set_id = TO_CHAR(to_number(USERENV('SESSIONID'))));
2064:
2065:
2066: /*
2067: ** If more than one row in the BOM_INVENTORY_COMPS_INTERFACE
2068: ** that contain the same bill_sequence_id,
2069: ** operation_seq_num and
2070: ** component_item_id,
2071: ** those rows will be combined into a single row and the

Line 2093: update BOM_INVENTORY_COMPS_INTERFACE

2089: ** different bill and
2090: ** not begining of the loop
2091: */
2092: if total_qty <> 0 then
2093: update BOM_INVENTORY_COMPS_INTERFACE
2094: set component_quantity = total_qty
2095: where component_sequence_id =
2096: save_comp_seq_id;
2097: end if;

Line 2109: update BOM_INVENTORY_COMPS_INTERFACE

2105: /*
2106: ** same bill but different item
2107: */
2108: if save_item_id <> item_id then
2109: update BOM_INVENTORY_COMPS_INTERFACE
2110: set component_quantity = total_qty
2111: where component_sequence_id
2112: = save_comp_seq_id;
2113: total_qty := qty;

Line 2119: update BOM_INVENTORY_COMPS_INTERFACE

2115: ** same bill and item but different seq_num
2116: */
2117: else
2118: if save_op_seq_num <> op_seq_num then
2119: update BOM_INVENTORY_COMPS_INTERFACE
2120: set component_quantity = total_qty
2121: where component_sequence_id
2122: = save_comp_seq_id;
2123:

Line 2129: delete BOM_INVENTORY_COMPS_INTERFACE

2125: /*
2126: ** duplicated one
2127: */
2128: else
2129: delete BOM_INVENTORY_COMPS_INTERFACE
2130: where component_sequence_id
2131: = save_comp_seq_id;
2132:
2133: total_qty := total_qty + qty;

Line 2146: update BOM_INVENTORY_COMPS_INTERFACE

2142: /*
2143: ** handle the last row here
2144: */
2145: stmt_num := 180;
2146: update BOM_INVENTORY_COMPS_INTERFACE
2147: set component_quantity = total_qty
2148: where component_sequence_id = save_comp_seq_id;
2149: close cc;
2150:

Line 2327: bom_inventory_comps_interface ic,

2323: ic.ORGANIZATION_ID,
2324: ic.COMPONENT_ITEM_ID,
2325: ic.operation_seq_num
2326: from
2327: bom_inventory_comps_interface ic,
2328: bom_reference_designators r,
2329: bom_bill_of_mtls_interface b
2330: where b.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
2331: and ic.bill_sequence_id = b.bill_sequence_id

Line 2346: bom_inventory_comps_interface bci,

2342: ( select /*+ ORDERED */
2343: NVL(max(v.element_value),i.element_value)
2344: from
2345: bom_bill_of_mtls_interface bi,
2346: bom_inventory_comps_interface bci,
2347: bom_inventory_components bc,
2348: bom_dependent_desc_elements be,
2349: mtl_descr_element_values v
2350: where bi.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))