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.EGO_ICC_STRUCTURE_PVT dependencies on BOM_COMPONENTS_B

Line 140: from BOM_COMPONENTS_B

136: IS
137: Cursor get_draft_components(p_bill_seq_id NUMBER)
138: IS
139: SELECT COMPONENT_SEQUENCE_ID
140: from BOM_COMPONENTS_B
141: where bill_sequence_id = p_bill_seq_id
142: and nvl(from_object_revision_id,0) = 0;
143:
144: Cursor get_version_components(p_bill_seq_id NUMBER)

Line 147: from BOM_COMPONENTS_B

143:
144: Cursor get_version_components(p_bill_seq_id NUMBER)
145: IS
146: SELECT COMPONENT_SEQUENCE_ID
147: from BOM_COMPONENTS_B
148: where bill_sequence_id = p_bill_seq_id
149: and from_object_revision_id = p_version_seq_id
150: and nvl(parent_bill_seq_id,p_bill_seq_id) = p_bill_seq_id;
151:

Line 190: delete from bom_components_b

186: for component in get_draft_components(l_bill_seq_id) loop
187: delete_comp_user_attrs(component.component_sequence_id);
188: end loop;
189:
190: delete from bom_components_b
191: where bill_sequence_id = l_bill_seq_id
192: and nvl(from_object_revision_id,0) = 0;
193:
194: select data_level_id

Line 207: Insert into BOM_COMPONENTS_B

203: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
204: into l_new_component_seq_id
205: from dual;
206:
207: Insert into BOM_COMPONENTS_B
208: (OPERATION_SEQ_NUM,
209: COMPONENT_ITEM_ID,
210: LAST_UPDATE_DATE,
211: LAST_UPDATED_BY,

Line 299: from BOM_COMPONENTS_B BCB

295: BCB.CHANGE_NOTICE,
296: BCB.BASIS_TYPE,
297: BCB.LOW_QUANTITY,
298: BCB.HIGH_QUANTITY
299: from BOM_COMPONENTS_B BCB
300: where BCB.COMPONENT_SEQUENCE_ID = component.component_sequence_id
301: and BCB.BILL_SEQUENCE_ID = l_bill_seq_id;
302:
303: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 393: from BOM_COMPONENTS_B

389: include_on_ship_docs,
390: required_for_revenue,
391: required_to_ship,
392: pick_components
393: from BOM_COMPONENTS_B
394: where bill_sequence_id = p_bill_seq_id
395: and nvl(parent_bill_seq_id,bill_sequence_id) = bill_sequence_id
396: and from_object_revision_id = p_ver_seq_id;
397:

Line 643: Insert into BOM_COMPONENTS_B

639: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
640: into l_new_component_seq_id
641: from dual;
642:
643: Insert into BOM_COMPONENTS_B
644: (OPERATION_SEQ_NUM,
645: COMPONENT_ITEM_ID,
646: LAST_UPDATE_DATE,
647: LAST_UPDATED_BY,

Line 907: from BOM_COMPONENTS_B

903: shipping_allowed,
904: include_on_ship_docs,
905: required_for_revenue,
906: required_to_ship
907: from BOM_COMPONENTS_B
908: where bill_sequence_id = p_bill_seq_id
909: and nvl(parent_bill_seq_id,bill_sequence_id) = bill_sequence_id
910: and from_object_revision_id = p_ver_seq_id;
911:

Line 947: from BOM_COMPONENTS_B

943: shipping_allowed,
944: include_on_ship_docs,
945: required_for_revenue,
946: required_to_ship
947: from BOM_COMPONENTS_B
948: where bill_sequence_id = p_bill_seq_id
949: and from_object_revision_id = p_ver_seq_id;
950:
951: Cursor parent_catalog

Line 1369: from bom_components_b

1365: wip_supply_type,check_atp,optional,
1366: mutually_exclusive_options,low_quantity,high_quantity,
1367: so_basis,shipping_allowed,include_on_ship_docs,
1368: required_for_revenue,required_to_ship
1369: from bom_components_b
1370: where COMPONENT_SEQUENCE_ID = p_draft_comp_seq_id)
1371: minus
1372: (select
1373: component_item_id,component_quantity,component_item_revision_id,

Line 1382: from bom_components_b

1378: wip_supply_type,check_atp,optional,
1379: mutually_exclusive_options,low_quantity,high_quantity,
1380: so_basis,shipping_allowed,include_on_ship_docs,
1381: required_for_revenue,required_to_ship
1382: from bom_components_b
1383: where COMPONENT_SEQUENCE_ID = p_released_comp_seq_id))
1384: union
1385: ((select
1386: component_item_id,component_quantity,component_item_revision_id,

Line 1395: from bom_components_b

1391: wip_supply_type,check_atp,optional,
1392: mutually_exclusive_options,low_quantity,high_quantity,
1393: so_basis,shipping_allowed,include_on_ship_docs,
1394: required_for_revenue,required_to_ship
1395: from bom_components_b
1396: where COMPONENT_SEQUENCE_ID = p_released_comp_seq_id)
1397: minus
1398: (select
1399: component_item_id,component_quantity,component_item_revision_id,

Line 1408: from bom_components_b

1404: wip_supply_type,check_atp,optional,
1405: mutually_exclusive_options,low_quantity,high_quantity,
1406: so_basis,shipping_allowed,include_on_ship_docs,
1407: required_for_revenue,required_to_ship
1408: from bom_components_b
1409: where COMPONENT_SEQUENCE_ID = p_draft_comp_seq_id)));
1410:
1411: -- Added as UT fix
1412: exception

Line 1488: select * from bom_components_b

1484: Return Number
1485: Is
1486:
1487: cursor components is
1488: select * from bom_components_b
1489: where bill_sequence_id = p_bill_seq_id;
1490:
1491: l_count Number := 0;
1492: l_return_val Number := 0;

Line 1515: FROM bom_components_b bic

1511: P_endItemOrgId Number,
1512: P_endItemId Number)
1513: is
1514: SELECT count(1)
1515: FROM bom_components_b bic
1516: WHERE bill_sequence_id = p_bill_seq_id
1517: AND component_sequence_id <> P_comp_seq_id
1518: AND nvl(obj_name,'EGO_ITEM') = nvl(P_obj_type,'EGO_ITEM')
1519: AND pk1_value = P_pk1_value

Line 1699: bom_components_b icc_str_components

1695: from mtl_item_catalog_groups_b
1696: connect by prior parent_catalog_group_id = item_catalog_group_id
1697: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
1698: bom_structures_b icc_structure,
1699: bom_components_b icc_str_components
1700: where icc_structure.pk1_value = icc.item_catalog_group_id
1701: and icc_structure.pk2_value = p_organization_id
1702: and icc_structure.obj_name = 'EGO_CATALOG_GROUP'
1703: and icc_structure.structure_type_id = p_structure_type_id

Line 2052: Insert into BOM_COMPONENTS_B

2048: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2049: into l_new_component_seq_id
2050: from dual;
2051: l_stmt_no := 340;
2052: Insert into BOM_COMPONENTS_B
2053: (OPERATION_SEQ_NUM,
2054: COMPONENT_ITEM_ID,
2055: LAST_UPDATE_DATE,
2056: LAST_UPDATED_BY,

Line 2152: from BOM_COMPONENTS_B BCB

2148: BCB.CHANGE_NOTICE,
2149: BCB.BASIS_TYPE,
2150: BCB.LOW_QUANTITY,
2151: BCB.HIGH_QUANTITY
2152: from BOM_COMPONENTS_B BCB
2153: where BCB.COMPONENT_SEQUENCE_ID = v_insert_comp_tbl(cntr).component_sequence_id;
2154: /* UT Fix : Commented as component_seq_id is primary key in bom_components_b */
2155: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id;
2156:

Line 2154: /* UT Fix : Commented as component_seq_id is primary key in bom_components_b */

2150: BCB.LOW_QUANTITY,
2151: BCB.HIGH_QUANTITY
2152: from BOM_COMPONENTS_B BCB
2153: where BCB.COMPONENT_SEQUENCE_ID = v_insert_comp_tbl(cntr).component_sequence_id;
2154: /* UT Fix : Commented as component_seq_id is primary key in bom_components_b */
2155: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id;
2156:
2157: l_stmt_no := 350;
2158: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 2301: bom_components_b icc_str_components

2297: from mtl_item_catalog_groups_b
2298: connect by prior parent_catalog_group_id = item_catalog_group_id
2299: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
2300: bom_structures_b icc_structure,
2301: bom_components_b icc_str_components
2302: where icc_structure.pk1_value = icc.item_catalog_group_id
2303: and icc_structure.pk2_value = p_organization_id
2304: and icc_structure.obj_name = 'EGO_CATALOG_GROUP'
2305: and icc_structure.structure_type_id = p_structure_type_id

Line 2425: from bom_components_b where bill_sequence_id = l_item_bill_sequence_id;

2421: end if;
2422:
2423: l_stmt_no := 60;
2424: select max(ITEM_NUM) into l_item_seq_incr
2425: from bom_components_b where bill_sequence_id = l_item_bill_sequence_id;
2426:
2427: l_stmt_no := 70;
2428: select bom_item_type,eam_item_type,base_item_id,replenish_to_order_flag,pick_components_flag,atp_components_flag
2429: into l_assy_bom_item_type,l_assy_eam_item_type,l_assy_base_item_id,l_assy_replenish_to_order_flag,l_assy_pick_components_flag,

Line 2600: from bom_components_b bcb

2596: /* Get components that are valid only for current revision */
2597: begin
2598: select bcb.component_sequence_id,bcb.component_item_id,bcb.from_end_item_rev_id,bcb.to_end_item_rev_id,bcb.inherit_flag
2599: bulk collect into v_item_comp_tbl
2600: from bom_components_b bcb
2601: where bcb.bill_sequence_id = l_item_bill_sequence_id
2602: and bcb.inherit_flag = 1
2603: and (p_rev_date between EGO_ICC_STRUCTURE_PVT.get_revision_start_date(bcb.from_end_item_rev_id) and
2604: EGO_ICC_STRUCTURE_PVT.get_revision_end_date(nvl(bcb.to_end_item_rev_id,-1)));

Line 2675: delete from bom_components_b

2671: /* Deleting the comp and its attributes. if it exists only for the current revision. */
2672: l_stmt_no := 320;
2673: Delete_Comp_User_Attrs(v_item_comp_tbl(cntr).component_sequence_id);
2674:
2675: delete from bom_components_b
2676: where component_sequence_id = v_item_comp_tbl(cntr).component_sequence_id;
2677:
2678: else
2679: if v_item_comp_tbl(cntr).to_end_item_rev_id is null then -- if-7

Line 2694: delete from bom_components_b

2690: /* Delete if component and its attributes which exists as B - null */
2691: l_stmt_no := 340;
2692: Delete_Comp_User_Attrs(v_item_comp_tbl(cntr).component_sequence_id);
2693:
2694: delete from bom_components_b
2695: where component_sequence_id = v_item_comp_tbl(cntr).component_sequence_id;
2696: end if; -- if-8
2697: else
2698: /* If to_rev_id is not null then update from_rev_id. For eg : C - null or C - D */

Line 2752: Insert into BOM_COMPONENTS_B

2748: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2749: into l_new_component_seq_id
2750: from dual;
2751: l_stmt_no := 420;
2752: Insert into BOM_COMPONENTS_B
2753: (OPERATION_SEQ_NUM,
2754: COMPONENT_ITEM_ID,
2755: LAST_UPDATE_DATE,
2756: LAST_UPDATED_BY,

Line 2852: from BOM_COMPONENTS_B BCB

2848: BCB.CHANGE_NOTICE,
2849: BCB.BASIS_TYPE,
2850: BCB.LOW_QUANTITY,
2851: BCB.HIGH_QUANTITY
2852: from BOM_COMPONENTS_B BCB
2853: where
2854: BCB.COMPONENT_SEQUENCE_ID = v_insert_comp_tbl(cntr).component_sequence_id;
2855: /* UT Fix : Commented as Comp_seq_id is alone enough to find a record in bom_components_b */
2856: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id) );

Line 2855: /* UT Fix : Commented as Comp_seq_id is alone enough to find a record in bom_components_b */

2851: BCB.HIGH_QUANTITY
2852: from BOM_COMPONENTS_B BCB
2853: where
2854: BCB.COMPONENT_SEQUENCE_ID = v_insert_comp_tbl(cntr).component_sequence_id;
2855: /* UT Fix : Commented as Comp_seq_id is alone enough to find a record in bom_components_b */
2856: -- and BCB.BILL_SEQUENCE_ID = l_catalog_bill_sequence_id) );
2857: l_stmt_no := 430;
2858: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,
2859: to_char(v_insert_comp_tbl(cntr).component_sequence_id)),

Line 2896: -- update bom_components_b based on v_update_comp_tbl.

2892: END IF;
2893:
2894: end loop;
2895: l_stmt_no := 460;
2896: -- update bom_components_b based on v_update_comp_tbl.
2897: -- Modified Since 10G doesn't support BULK In-BIND table of records. Only 11G supports it.
2898:
2899: /* forall upd_index in v_update_comp_tbl.first..v_update_comp_tbl.last
2900: update bom_components_b set

Line 2900: update bom_components_b set

2896: -- update bom_components_b based on v_update_comp_tbl.
2897: -- Modified Since 10G doesn't support BULK In-BIND table of records. Only 11G supports it.
2898:
2899: /* forall upd_index in v_update_comp_tbl.first..v_update_comp_tbl.last
2900: update bom_components_b set
2901: from_end_item_rev_id = v_update_comp_tbl(upd_index).from_revision_id,
2902: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2903: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,
2904: last_update_date = sysdate,

Line 2913: update bom_components_b

2909: l_stmt_no := 470;
2910: if v_update_comp_tbl.exists(v_update_comp_tbl.first) then
2911: for upd_index in v_update_comp_tbl.first..v_update_comp_tbl.last
2912: loop
2913: update bom_components_b
2914: set
2915: from_end_item_rev_id = v_update_comp_tbl(upd_index).from_revision_id,
2916: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2917: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,

Line 2976: bom_components_b icc_str_components

2972: from mtl_item_catalog_groups_b
2973: connect by prior parent_catalog_group_id = item_catalog_group_id
2974: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
2975: bom_structures_b icc_structure,
2976: bom_components_b icc_str_components
2977: where icc_structure.pk1_value = icc.item_catalog_group_id
2978: and icc_structure.pk2_value = p_organization_id
2979: and icc_structure.obj_name = 'EGO_CATALOG_GROUP'
2980: and icc_structure.structure_type_id = p_structure_type_id