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

Line 917: from bom_inventory_comps_interface

913: where parent_ato_line_id=xlineid
914: and parent_ato_line_id <> line_id /* to avoid selecting top model */
915: minus
916: select revised_item_sequence_id /* new column used to store line_id */
917: from bom_inventory_comps_interface
918: where bill_sequence_id = xconfigbillid
919: and greatest(sysdate, xEstRelDate ) >= effectivity_date
920: and (( disable_date is null ) or ( disable_date is not null and greatest(sysdate, xEstRelDate) <= disable_date )) ;
921:

Line 931: bom_inventory_comps_interface b1,

927: b1.component_item_id,
928: b1.component_quantity,
929: nvl(b1.optional_on_model, 1)
930: from
931: bom_inventory_comps_interface b1,
932: bom_inventory_comps_interface b2
933: where b1.bill_sequence_id = b2.bill_sequence_id
934: and b1.component_sequence_id <> b2.component_sequence_id
935: and b1.operation_seq_num = b2.operation_seq_num

Line 932: bom_inventory_comps_interface b2

928: b1.component_quantity,
929: nvl(b1.optional_on_model, 1)
930: from
931: bom_inventory_comps_interface b1,
932: bom_inventory_comps_interface b2
933: where b1.bill_sequence_id = b2.bill_sequence_id
934: and b1.component_sequence_id <> b2.component_sequence_id
935: and b1.operation_seq_num = b2.operation_seq_num
936: and b1.component_item_id = b2.component_item_id

Line 1109: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

1105: -- this case the two records at 15 needs to be clubbed but not the once at 25 and 30. Going
1106: -- just by item_id will club all 4 records. We need to go by item_id and op_seq.
1107: cursor club_comp is
1108: select distinct b1.component_item_id item_id, b1.operation_seq_num
1109: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
1110: where b1.bill_sequence_id = b2.bill_sequence_id
1111: and b1.component_sequence_id <> b2.component_sequence_id
1112: and b1.operation_seq_num = b2.operation_seq_num
1113: and b1.component_item_id = b2.component_item_id

Line 1127: from bom_inventory_comps_interface

1123: cursor c1_debug( xItemId number, xOperation_seq_num number) is
1124: select effectivity_date eff_date,
1125: nvl (disable_date,g_SchShpDate) dis_date,
1126: component_quantity cmp_qty
1127: from bom_inventory_comps_interface
1128: where bill_sequence_id = lConfigBillId
1129: and component_item_id = xItemId
1130: and operation_seq_num = xOperation_seq_num; --4244576
1131: -- bugfix 3985173

Line 1184: from bom_inventory_comps_interface

1180: --- Renga
1181:
1182: cursor Debug_cur is
1183: select assembly_item_id,component_item_id,operation_seq_num,max(disable_date) disable_date
1184: from bom_inventory_comps_interface
1185: where bill_sequence_id = lconfigbillid
1186: group by assembly_item_id,component_item_id,operation_seq_num;
1187:
1188: --- End Renga

Line 1265: BOM_INVENTORY_COMPS_INTERFACE table.

1261: /*-----------------------------------------------------------+
1262: First:
1263: All the chosen option items/models/Classes associated
1264: with the new configuration items will be loaded into the
1265: BOM_INVENTORY_COMPS_INTERFACE table.
1266: +-------------------------------------------------------------*/
1267:
1268: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1269: lStmtNum := 30;

Line 1268: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

1264: with the new configuration items will be loaded into the
1265: BOM_INVENTORY_COMPS_INTERFACE table.
1266: +-------------------------------------------------------------*/
1267:
1268: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1269: lStmtNum := 30;
1270:
1271: -- rkaza. bug 4524248. bom structure import enhancements.
1272: -- Added batch_id

Line 1274: insert into BOM_INVENTORY_COMPS_INTERFACE

1270:
1271: -- rkaza. bug 4524248. bom structure import enhancements.
1272: -- Added batch_id
1273:
1274: insert into BOM_INVENTORY_COMPS_INTERFACE
1275: (
1276: operation_seq_num,
1277: component_item_id,
1278: last_update_date,

Line 1470: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);

1466: or
1467: bcol3.line_id = bcol1.parent_ato_line_id)
1468: and bcol3.line_id = bcol1.link_to_line_id;
1469:
1470: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);
1471:
1472:
1473: /* begin 04-04-2005 */
1474:

Line 1475: select count(*) into v_zero_qty_count from bom_inventory_comps_interface

1471:
1472:
1473: /* begin 04-04-2005 */
1474:
1475: select count(*) into v_zero_qty_count from bom_inventory_comps_interface
1476: where bill_sequence_id = lConfigBillId and component_quantity = 0 ;
1477:
1478:
1479: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;

Line 1524: BOM_INVENTORY_COMPS_INTERFACE table.

1520: /*---------------------------------------------------------------+
1521: Second:
1522: All the standard component items associated
1523: with the new configuration items will be loaded into the
1524: BOM_INVENTORY_COMPS_INTERFACE table.
1525: +----------------------------------------------------------------*/
1526:
1527: lStmtNum := 50;
1528: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

Line 1528: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

1524: BOM_INVENTORY_COMPS_INTERFACE table.
1525: +----------------------------------------------------------------*/
1526:
1527: lStmtNum := 50;
1528: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1529: insert into BOM_INVENTORY_COMPS_INTERFACE
1530: (
1531: operation_seq_num,
1532: component_item_id,

Line 1529: insert into BOM_INVENTORY_COMPS_INTERFACE

1525: +----------------------------------------------------------------*/
1526:
1527: lStmtNum := 50;
1528: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1529: insert into BOM_INVENTORY_COMPS_INTERFACE
1530: (
1531: operation_seq_num,
1532: component_item_id,
1533: last_update_date,

Line 1700: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);

1696: and ( ic1.disable_date is null or
1697: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
1698: and ic1.bom_item_type = 4;
1699:
1700: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);
1701:
1702:
1703:
1704: /* begin Extend Effectivity Dates for Option Items with disable date */

Line 1717: update bom_inventory_comps_interface

1713: WriteToLog('create_bom_ml: : MAxDisbale Date = '||debug_rec.disable_date,1);
1714: WriteToLog('==================================',1);
1715: End Loop;
1716:
1717: update bom_inventory_comps_interface
1718: set disable_date = g_futuredate
1719: where (component_item_id, nvl(assembly_item_id,-1),disable_date)
1720: in ( select
1721: component_item_id, nvl(assembly_item_id,-1),max(disable_date)

Line 1722: from bom_inventory_comps_interface

1718: set disable_date = g_futuredate
1719: where (component_item_id, nvl(assembly_item_id,-1),disable_date)
1720: in ( select
1721: component_item_id, nvl(assembly_item_id,-1),max(disable_date)
1722: from bom_inventory_comps_interface
1723: where bill_sequence_id = lConfigBillId
1724: group by component_item_id, assembly_item_id
1725: )
1726: and bill_sequence_id = lConfigBillId

Line 1748: ( select * from bom_inventory_comps_interface

1744: begin
1745: select 1 into v_overlap_check
1746: from dual
1747: where exists
1748: ( select * from bom_inventory_comps_interface
1749: where bill_sequence_id = lConfigBillId
1750: group by component_item_id, assembly_item_id
1751: having count(distinct operation_seq_num) > 1
1752: );

Line 1769: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2

1765: BULK COLLECT INTO
1766: v_t_overlap_comp_item_id,
1767: v_t_overlap_src_op_seq_num, v_t_overlap_src_eff_date, v_t_overlap_src_disable_date ,
1768: v_t_overlap_dest_op_seq_num , v_t_overlap_dest_eff_date, v_t_overlap_dest_disable_date
1769: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2
1770: where s1.component_item_id = s2.component_item_id and s1.assembly_item_id = s2.assembly_item_id
1771: and s1.effectivity_date between s2.effectivity_date and s2.disable_date
1772: and s1.component_sequence_id <> s2.component_sequence_id ;
1773:

Line 2213: insert into BOM_INVENTORY_COMPS_INTERFACE

2209: Third : Get the base model row into BOM_INVENTORY_COMPONENTS
2210: +----------------------------------------------------------------*/
2211:
2212: lStmtNum := 60;
2213: insert into BOM_INVENTORY_COMPS_INTERFACE
2214: (
2215: operation_seq_num,
2216: component_item_id,
2217: last_update_date,

Line 2348: WriteToLog('Inserted ' || lCnt ||' rows into bom_inventory_comps_interface',3);

2344: and bcol.ordered_quantity <> 0
2345: and bcol.inventory_item_id = pModelId;
2346:
2347: lCnt := sql%rowcount ;
2348: WriteToLog('Inserted ' || lCnt ||' rows into bom_inventory_comps_interface',3);
2349:
2350: xBillId := lConfigBillId;
2351:
2352: --

Line 3447: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

3443: config routing, the operation_seq_num will be
3444: set to 1.
3445: +--------------------------------------------------------------*/
3446: lStmtNum := 130;
3447: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
3448:
3449: update bom_inventory_comps_interface ci
3450: set ci.operation_seq_num = 1
3451: where not exists

Line 3449: update bom_inventory_comps_interface ci

3445: +--------------------------------------------------------------*/
3446: lStmtNum := 130;
3447: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
3448:
3449: update bom_inventory_comps_interface ci
3450: set ci.operation_seq_num = 1
3451: where not exists
3452: (select 'op seq exists in config routing'
3453: from

Line 3640: from bom_inventory_comps_interface

3636: where organization_id = pOrgId
3637: and alternate_routing_designator is null
3638: and assembly_item_id in
3639: ( select component_item_id
3640: from bom_inventory_comps_interface
3641: where bom_item_type =2
3642: and bill_sequence_id = lConfigBillId
3643: )
3644: and serialization_start_op in

Line 3687: If more than one row in the BOM_INVENTORY_COMPS_INTERFACE

3683:
3684:
3685:
3686: /*--------------------------------------------------------------+
3687: If more than one row in the BOM_INVENTORY_COMPS_INTERFACE
3688: that contain the same bill_sequence_id, operation_seq_num and
3689: component_item_id, those rows will be combined into a
3690: single row and the accumulated COMPONENT_QUANTITY will be
3691: used in the row.

Line 3701: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

3697: -- 4244576 - Also need to get operstion_seq_num into an array.
3698:
3699: select b1.model_comp_seq_id, b1.component_item_id, b1.operation_seq_num
3700: BULK COLLECT INTO model_comp_seq_id_arr, component_item_id_arr, operation_seq_num_arr
3701: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
3702: where b1.bill_sequence_id = b2.bill_sequence_id
3703: and b1.component_sequence_id <> b2.component_sequence_id
3704: and b1.operation_seq_num = b2.operation_seq_num
3705: and b1.component_item_id = b2.component_item_id

Line 3709: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

3705: and b1.component_item_id = b2.component_item_id
3706: and b1.bill_sequence_id = lConfigBillId
3707: UNION
3708: select b2.model_comp_seq_id, b2.component_item_id, b2.operation_seq_num
3709: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
3710: where b1.bill_sequence_id = b2.bill_sequence_id
3711: and b1.component_sequence_id <> b2.component_sequence_id
3712: and b1.operation_seq_num = b2.operation_seq_num
3713: and b1.component_item_id = b2.component_item_id

Line 3763: update bom_inventory_comps_interface

3759: *--------------------------------------------+
3760: different bill and not begining of the loop
3761: +--------------------------------------------*
3762: if lTotalQty <> 0 then
3763: update bom_inventory_comps_interface
3764: set component_quantity = Round( lTotalQty, 7) * Decimal-Qty Support for Option Items *
3765: where component_sequence_id = lSaveCompSeqId;
3766: end if;
3767:

Line 3769: update bom_inventory_comps_interface

3765: where component_sequence_id = lSaveCompSeqId;
3766: end if;
3767:
3768: if lSaveOptional = 1 then
3769: update bom_inventory_comps_interface
3770: set optional_on_model = lSaveOptional
3771: where component_sequence_id = lSaveCompSeqId;
3772: end if;
3773:

Line 3787: update bom_inventory_comps_interface

3783: *-----------------------------------------------+
3784: same bill but different item
3785: +------------------------------------------------*
3786: if lSaveItemId <> lItemId then
3787: update bom_inventory_comps_interface
3788: set component_quantity = Round( lTotalQty, 7 ) * Decimal-Qty Support for Option Items *
3789: where component_sequence_id = lSaveCompSeqId;
3790:
3791: if lSaveOptional = 1 then

Line 3792: update bom_inventory_comps_interface

3788: set component_quantity = Round( lTotalQty, 7 ) * Decimal-Qty Support for Option Items *
3789: where component_sequence_id = lSaveCompSeqId;
3790:
3791: if lSaveOptional = 1 then
3792: update bom_inventory_comps_interface
3793: set optional_on_model = lSaveOptional
3794: where component_sequence_id = lSaveCompSeqId;
3795: end if;
3796:

Line 3804: update bom_inventory_comps_interface

3800: same bill and item but different seq_num
3801: +---------------------------------------------*
3802: else
3803: if lSaveOpSeqNum <> lOpSeqNum then
3804: update bom_inventory_comps_interface
3805: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3806: where component_sequence_id = lSaveCompSeqId;
3807: lTotalQty := lqty;
3808:

Line 3810: update bom_inventory_comps_interface

3806: where component_sequence_id = lSaveCompSeqId;
3807: lTotalQty := lqty;
3808:
3809: if lSaveOptional = 1 then
3810: update bom_inventory_comps_interface
3811: set optional_on_model = lSaveOptional
3812: where component_sequence_id = lSaveCompSeqId;
3813: end if;
3814: lSaveOptional := lOptional;

Line 3819: delete bom_inventory_comps_interface

3815: *----------------------------------+
3816: duplicated one
3817: +----------------------------------*
3818: else
3819: delete bom_inventory_comps_interface
3820: where component_sequence_id = lSaveCompSeqId;
3821: lTotalQty := lTotalQty + lqty;
3822: if lOptional = 1 then
3823: lSaveOptional := 1;

Line 3841: update bom_inventory_comps_interface

3837: WriteToLog('Consolidate_components:lTotalQty: ' || to_char(lTotalQty), 5);
3838: WriteToLog('Consolidate_components:ComponentSeqID: ' || to_char(lSaveCompSeqId), 5);
3839:
3840: lStmtNum := 140;
3841: update bom_inventory_comps_interface
3842: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3843: where component_sequence_id = lSaveCompSeqId;
3844:
3845: if lSaveOptional = 1 then

Line 3846: update bom_inventory_comps_interface

3842: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3843: where component_sequence_id = lSaveCompSeqId;
3844:
3845: if lSaveOptional = 1 then
3846: update bom_inventory_comps_interface
3847: set optional_on_model = lSaveOptional
3848: where component_sequence_id = lSaveCompSeqId;
3849: end if;
3850: close consolidate_components;

Line 3882: from bom_inventory_comps_interface

3878: WriteToLog( ' Looping for item id : ' ||club_comp_rec.item_id ||' operation_seq : '||club_comp_rec.operation_seq_num,1);
3879:
3880: select distinct effectivity_date
3881: BULK COLLECT INTO asc_date_arr
3882: from bom_inventory_comps_interface
3883: where bill_sequence_id = lConfigBillId
3884: and component_item_id = club_comp_rec.item_id
3885: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3886: UNION

Line 3888: from bom_inventory_comps_interface

3884: and component_item_id = club_comp_rec.item_id
3885: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3886: UNION
3887: select distinct disable_date
3888: from bom_inventory_comps_interface
3889: where bill_sequence_id = lConfigBillId
3890: and component_item_id = club_comp_rec.item_id
3891: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3892: order by 1;

Line 4004: bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

4000: select b1.model_comp_seq_id, b1.component_item_id
4001: BULK COLLECT INTO
4002: basis_model_comp_seq_id_arr, basis_component_item_id_arr
4003: from
4004: bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
4005: where b1.bill_sequence_id = b2.bill_sequence_id
4006: and b1.component_sequence_id <> b2.component_sequence_id
4007: and b1.operation_seq_num = b2.operation_seq_num
4008: and b1.component_item_id = b2.component_item_id

Line 4092: from bom_inventory_comps_interface

4088:
4089: select max(rowid), sum(decode(basis_type, 1, component_quantity, 0))
4090: + max(decode(basis_type, 2, component_quantity, 0)) /* LBM Project */
4091: into club_tab_arr(x4).row_id,club_tab_arr(x4).qty
4092: from bom_inventory_comps_interface
4093: where effectivity_date <= club_tab_arr(x4).eff_dt
4094: and nvl(disable_date,g_SchShpDate) >= club_tab_arr(x4).dis_dt
4095: and bill_sequence_id = lConfigBillId
4096: and component_item_id = club_comp_rec.item_id

Line 4114: -- Now insert into bom_inventory_comps_interface

4110: END IF;
4111: end loop;
4112: end if;
4113:
4114: -- Now insert into bom_inventory_comps_interface
4115:
4116: if club_tab_arr.count > 0 then
4117:
4118: for x6 in club_tab_arr.FIRST.. club_tab_arr.LAST

Line 4121: insert into bom_inventory_comps_interface

4117:
4118: for x6 in club_tab_arr.FIRST.. club_tab_arr.LAST
4119: loop
4120: If nvl(club_tab_arr(x6).qty,0) <> 0 Then
4121: insert into bom_inventory_comps_interface
4122: (
4123: component_item_id,
4124: bill_sequence_id,
4125: effectivity_date,

Line 4254: from bom_inventory_comps_interface

4250: plan_level,
4251: revised_item_sequence_id
4252: , nvl(basis_type,1), /* LBM project */
4253: cto_msutil_pub.bom_batch_id
4254: from bom_inventory_comps_interface
4255: where component_item_id = club_comp_rec.item_id
4256: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4257: and bill_sequence_id = lConfigBillId
4258: and rowid = club_tab_arr(x6).row_id;

Line 4264: delete from bom_inventory_comps_interface

4260: end loop;
4261: end if;
4262:
4263: -- Delete original option item rows from bici
4264: delete from bom_inventory_comps_interface
4265: where component_item_id = club_comp_rec.item_id
4266: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4267: and bill_sequence_id = lConfigBillId
4268: and created_by <> lConfigBillId;

Line 4270: -- Delete rows from bom_inventory_comps_interface where qty = 0

4266: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4267: and bill_sequence_id = lConfigBillId
4268: and created_by <> lConfigBillId;
4269:
4270: -- Delete rows from bom_inventory_comps_interface where qty = 0
4271: delete from bom_inventory_comps_interface
4272: where component_item_id = club_comp_rec.item_id
4273: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4274: and bill_sequence_id = lConfigBillId

Line 4271: delete from bom_inventory_comps_interface

4267: and bill_sequence_id = lConfigBillId
4268: and created_by <> lConfigBillId;
4269:
4270: -- Delete rows from bom_inventory_comps_interface where qty = 0
4271: delete from bom_inventory_comps_interface
4272: where component_item_id = club_comp_rec.item_id
4273: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4274: and bill_sequence_id = lConfigBillId
4275: and created_by = lConfigBillId

Line 4330: update bom_inventory_comps_interface

4326: p_item_num := p_item_num + p_seq_increment;
4327:
4328: WriteToLog('p_item_num::'||to_char(p_item_num), 5);
4329:
4330: update bom_inventory_comps_interface
4331: set item_num = p_item_num
4332: where bill_sequence_id = lConfigbillid and parent_bill_seq_id = 0; /* 04-04-2005 bugfix 3374548 */
4333:
4334:

Line 4349: from bom_inventory_comps_interface

4345: into p_bill_seq_id
4346: from bom_bill_of_materials
4347: where assembly_item_id =
4348: (select component_item_id
4349: from bom_inventory_comps_interface
4350: where bill_sequence_id = lConfigBillId and parent_bill_seq_id = 0) /* Introduced by sushant */
4351: and organization_id = pOrgId
4352: and alternate_bom_designator is null;
4353:

Line 4666: from bom_inventory_comps_interface b,

4662: b.parent_bill_seq_id, --isp bom
4663: b.plan_level, --isp bom
4664: b.model_comp_seq_id --isp bom
4665: , decode(b.basis_type,1,null,b.basis_type) /* LBM change */
4666: from bom_inventory_comps_interface b,
4667: mtl_system_items msi
4668: where b.bill_sequence_id = lConfigBillId
4669: and b.component_item_id = msi.inventory_item_id
4670: and msi.organization_id = pOrgId;

Line 4780: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s

4776: ,creation_date
4777: ,created_by
4778: ,last_update_login
4779: */
4780: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
4781: where b.bill_sequence_id = lConfigBillId
4782: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
4783: and bic.optional = 2 /* only mandatory components */
4784: and bic.component_sequence_id = s.component_sequence_id ;

Line 5273: /* Clean up bom_inventory_comps_interface */

5269: );
5270:
5271: lStmtNum := 380;
5272:
5273: /* Clean up bom_inventory_comps_interface */
5274:
5275: delete from bom_inventory_comps_interface
5276: where bill_sequence_id = lConfigBillId;
5277:

Line 5275: delete from bom_inventory_comps_interface

5271: lStmtNum := 380;
5272:
5273: /* Clean up bom_inventory_comps_interface */
5274:
5275: delete from bom_inventory_comps_interface
5276: where bill_sequence_id = lConfigBillId;
5277:
5278: lCnt := sql%rowcount;
5279: WriteToLog('Deleted from bici, rows::'||lCnt);

Line 5804: from bom_inventory_comps_interface

5800:
5801: CURSOR c_update_item_num(p_parent_bill_seq_id number) IS
5802: select component_sequence_id,
5803: component_item_id
5804: from bom_inventory_comps_interface
5805: where parent_bill_seq_id = p_parent_bill_seq_id
5806: FOR UPDATE OF item_num;
5807:
5808: p_bill_seq_id number;

Line 5820: update bom_inventory_comps_interface

5816:
5817: --
5818: -- update item_num of child of this model
5819: --
5820: update bom_inventory_comps_interface
5821: set item_num = p_item_num
5822: where current of c_update_item_num;
5823:
5824: WriteToLog('Updated item '||to_char(v_update_item_num.component_item_id)|| ' with item num '||to_char(p_item_num), 5);

Line 6524: insert into BOM_INVENTORY_COMPS_INTERFACE

6520:
6521: lStmtNumber := 550;
6522:
6523: /*Insert into bic interface*/
6524: insert into BOM_INVENTORY_COMPS_INTERFACE
6525: ( operation_seq_num,
6526: component_item_id,
6527: last_update_date,
6528: last_updated_by,

Line 6666: update bom_inventory_comps_interface

6662: where bill_sequence_id = pConfigBillId;
6663:
6664: lCnt := sql%rowcount ;
6665: WriteToLog('Inherit_op_seq_ml:Inserted in BIC Interface ' || lCnt ||' rows from BET', 4);
6666: update bom_inventory_comps_interface
6667: set disable_date = g_futuredate
6668: where (component_item_id, operation_seq_num,disable_date)
6669: in ( select
6670: component_item_id, operation_seq_num,max(disable_date)

Line 6671: from bom_inventory_comps_interface

6667: set disable_date = g_futuredate
6668: where (component_item_id, operation_seq_num,disable_date)
6669: in ( select
6670: component_item_id, operation_seq_num,max(disable_date)
6671: from bom_inventory_comps_interface
6672: where bill_sequence_id = pConfigBillId
6673: group by component_item_id, operation_seq_num, assembly_item_id
6674: )
6675: and bill_sequence_id = pConfigBillId

Line 6691: ( select * from bom_inventory_comps_interface

6687: begin
6688: select 1 into v_overlap_check
6689: from dual
6690: where exists
6691: ( select * from bom_inventory_comps_interface
6692: where bill_sequence_id = pConfigBillId
6693: group by component_item_id, assembly_item_id
6694: having count(distinct operation_seq_num) > 1
6695: );

Line 6712: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2

6708: BULK COLLECT INTO
6709: v_t_overlap_comp_item_id,
6710: v_t_overlap_src_op_seq_num, v_t_overlap_src_eff_date, v_t_overlap_src_disable_date ,
6711: v_t_overlap_dest_op_seq_num , v_t_overlap_dest_eff_date, v_t_overlap_dest_disable_date
6712: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2
6713: where s1.component_item_id = s2.component_item_id and s1.assembly_item_id = s2.assembly_item_id
6714: and s1.effectivity_date between s2.effectivity_date and s2.disable_date
6715: and s1.component_sequence_id <> s2.component_sequence_id ;
6716: