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 860: from bom_inventory_comps_interface

856: where parent_ato_line_id=xlineid
857: and parent_ato_line_id <> line_id /* to avoid selecting top model */
858: minus
859: select revised_item_sequence_id /* new column used to store line_id */
860: from bom_inventory_comps_interface
861: where bill_sequence_id = xconfigbillid
862: and greatest(sysdate, xEstRelDate ) >= effectivity_date
863: and (( disable_date is null ) or ( disable_date is not null and greatest(sysdate, xEstRelDate) <= disable_date )) ;
864:

Line 874: bom_inventory_comps_interface b1,

870: b1.component_item_id,
871: b1.component_quantity,
872: nvl(b1.optional_on_model, 1)
873: from
874: bom_inventory_comps_interface b1,
875: bom_inventory_comps_interface b2
876: where b1.bill_sequence_id = b2.bill_sequence_id
877: and b1.component_sequence_id <> b2.component_sequence_id
878: and b1.operation_seq_num = b2.operation_seq_num

Line 875: bom_inventory_comps_interface b2

871: b1.component_quantity,
872: nvl(b1.optional_on_model, 1)
873: from
874: bom_inventory_comps_interface b1,
875: bom_inventory_comps_interface b2
876: where b1.bill_sequence_id = b2.bill_sequence_id
877: and b1.component_sequence_id <> b2.component_sequence_id
878: and b1.operation_seq_num = b2.operation_seq_num
879: and b1.component_item_id = b2.component_item_id

Line 1050: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

1046: -- this case the two records at 15 needs to be clubbed but not the once at 25 and 30. Going
1047: -- just by item_id will club all 4 records. We need to go by item_id and op_seq.
1048: cursor club_comp is
1049: select distinct b1.component_item_id item_id, b1.operation_seq_num
1050: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
1051: where b1.bill_sequence_id = b2.bill_sequence_id
1052: and b1.component_sequence_id <> b2.component_sequence_id
1053: and b1.operation_seq_num = b2.operation_seq_num
1054: and b1.component_item_id = b2.component_item_id

Line 1068: from bom_inventory_comps_interface

1064: cursor c1_debug( xItemId number, xOperation_seq_num number) is
1065: select effectivity_date eff_date,
1066: nvl (disable_date,g_SchShpDate) dis_date,
1067: component_quantity cmp_qty
1068: from bom_inventory_comps_interface
1069: where bill_sequence_id = lConfigBillId
1070: and component_item_id = xItemId
1071: and operation_seq_num = xOperation_seq_num; --4244576
1072: -- bugfix 3985173

Line 1125: from bom_inventory_comps_interface

1121: --- Renga
1122:
1123: cursor Debug_cur is
1124: select assembly_item_id,component_item_id,operation_seq_num,max(disable_date) disable_date
1125: from bom_inventory_comps_interface
1126: where bill_sequence_id = lconfigbillid
1127: group by assembly_item_id,component_item_id,operation_seq_num;
1128:
1129: --- End Renga

Line 1206: BOM_INVENTORY_COMPS_INTERFACE table.

1202: /*-----------------------------------------------------------+
1203: First:
1204: All the chosen option items/models/Classes associated
1205: with the new configuration items will be loaded into the
1206: BOM_INVENTORY_COMPS_INTERFACE table.
1207: +-------------------------------------------------------------*/
1208:
1209: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1210: lStmtNum := 30;

Line 1209: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

1205: with the new configuration items will be loaded into the
1206: BOM_INVENTORY_COMPS_INTERFACE table.
1207: +-------------------------------------------------------------*/
1208:
1209: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1210: lStmtNum := 30;
1211:
1212: -- rkaza. bug 4524248. bom structure import enhancements.
1213: -- Added batch_id

Line 1215: insert into BOM_INVENTORY_COMPS_INTERFACE

1211:
1212: -- rkaza. bug 4524248. bom structure import enhancements.
1213: -- Added batch_id
1214:
1215: insert into BOM_INVENTORY_COMPS_INTERFACE
1216: (
1217: operation_seq_num,
1218: component_item_id,
1219: last_update_date,

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

1407: or
1408: bcol3.line_id = bcol1.parent_ato_line_id)
1409: and bcol3.line_id = bcol1.link_to_line_id;
1410:
1411: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);
1412:
1413:
1414: /* begin 04-04-2005 */
1415:

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

1412:
1413:
1414: /* begin 04-04-2005 */
1415:
1416: select count(*) into v_zero_qty_count from bom_inventory_comps_interface
1417: where bill_sequence_id = lConfigBillId and component_quantity = 0 ;
1418:
1419:
1420: WriteToLog( 'MODELS: CHECK Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;

Line 1465: BOM_INVENTORY_COMPS_INTERFACE table.

1461: /*---------------------------------------------------------------+
1462: Second:
1463: All the standard component items associated
1464: with the new configuration items will be loaded into the
1465: BOM_INVENTORY_COMPS_INTERFACE table.
1466: +----------------------------------------------------------------*/
1467:
1468: lStmtNum := 50;
1469: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

Line 1469: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

1465: BOM_INVENTORY_COMPS_INTERFACE table.
1466: +----------------------------------------------------------------*/
1467:
1468: lStmtNum := 50;
1469: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1470: insert into BOM_INVENTORY_COMPS_INTERFACE
1471: (
1472: operation_seq_num,
1473: component_item_id,

Line 1470: insert into BOM_INVENTORY_COMPS_INTERFACE

1466: +----------------------------------------------------------------*/
1467:
1468: lStmtNum := 50;
1469: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
1470: insert into BOM_INVENTORY_COMPS_INTERFACE
1471: (
1472: operation_seq_num,
1473: component_item_id,
1474: last_update_date,

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

1637: and ( ic1.disable_date is null or
1638: (ic1.disable_date is not null and ic1.disable_date >= sysdate )) /* New Approach for Effectivity Dates */
1639: and ic1.bom_item_type = 4;
1640:
1641: WriteToLog('Inserted ' || sql%rowcount ||' rows into BOM_INVENTORY_COMPS_INTERFACE.',3);
1642:
1643:
1644:
1645: /* begin Extend Effectivity Dates for Option Items with disable date */

Line 1658: update bom_inventory_comps_interface

1654: WriteToLog('create_bom_ml: : MAxDisbale Date = '||debug_rec.disable_date,1);
1655: WriteToLog('==================================',1);
1656: End Loop;
1657:
1658: update bom_inventory_comps_interface
1659: set disable_date = g_futuredate
1660: where (component_item_id, nvl(assembly_item_id,-1),disable_date)
1661: in ( select
1662: component_item_id, nvl(assembly_item_id,-1),max(disable_date)

Line 1663: from bom_inventory_comps_interface

1659: set disable_date = g_futuredate
1660: where (component_item_id, nvl(assembly_item_id,-1),disable_date)
1661: in ( select
1662: component_item_id, nvl(assembly_item_id,-1),max(disable_date)
1663: from bom_inventory_comps_interface
1664: where bill_sequence_id = lConfigBillId
1665: group by component_item_id, assembly_item_id
1666: )
1667: and bill_sequence_id = lConfigBillId

Line 1689: ( select * from bom_inventory_comps_interface

1685: begin
1686: select 1 into v_overlap_check
1687: from dual
1688: where exists
1689: ( select * from bom_inventory_comps_interface
1690: where bill_sequence_id = lConfigBillId
1691: group by component_item_id, assembly_item_id
1692: having count(distinct operation_seq_num) > 1
1693: );

Line 1710: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2

1706: BULK COLLECT INTO
1707: v_t_overlap_comp_item_id,
1708: v_t_overlap_src_op_seq_num, v_t_overlap_src_eff_date, v_t_overlap_src_disable_date ,
1709: v_t_overlap_dest_op_seq_num , v_t_overlap_dest_eff_date, v_t_overlap_dest_disable_date
1710: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2
1711: where s1.component_item_id = s2.component_item_id and s1.assembly_item_id = s2.assembly_item_id
1712: and s1.effectivity_date between s2.effectivity_date and s2.disable_date
1713: and s1.component_sequence_id <> s2.component_sequence_id ;
1714:

Line 2124: insert into BOM_INVENTORY_COMPS_INTERFACE

2120: Third : Get the base model row into BOM_INVENTORY_COMPONENTS
2121: +----------------------------------------------------------------*/
2122:
2123: lStmtNum := 60;
2124: insert into BOM_INVENTORY_COMPS_INTERFACE
2125: (
2126: operation_seq_num,
2127: component_item_id,
2128: last_update_date,

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

2255: and bcol.ordered_quantity <> 0
2256: and bcol.inventory_item_id = pModelId;
2257:
2258: lCnt := sql%rowcount ;
2259: WriteToLog('Inserted ' || lCnt ||' rows into bom_inventory_comps_interface',3);
2260:
2261: xBillId := lConfigBillId;
2262:
2263: --

Line 3327: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';

3323: config routing, the operation_seq_num will be
3324: set to 1.
3325: +--------------------------------------------------------------*/
3326: lStmtNum := 130;
3327: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
3328:
3329: update bom_inventory_comps_interface ci
3330: set ci.operation_seq_num = 1
3331: where not exists

Line 3329: update bom_inventory_comps_interface ci

3325: +--------------------------------------------------------------*/
3326: lStmtNum := 130;
3327: xTableName := 'BOM_INVENTORY_COMPS_INTERFACE';
3328:
3329: update bom_inventory_comps_interface ci
3330: set ci.operation_seq_num = 1
3331: where not exists
3332: (select 'op seq exists in config routing'
3333: from

Line 3490: from bom_inventory_comps_interface

3486: where organization_id = pOrgId
3487: and alternate_routing_designator is null
3488: and assembly_item_id in
3489: ( select component_item_id
3490: from bom_inventory_comps_interface
3491: where bom_item_type =2
3492: and bill_sequence_id = lConfigBillId
3493: )
3494: and serialization_start_op in

Line 3537: If more than one row in the BOM_INVENTORY_COMPS_INTERFACE

3533:
3534:
3535:
3536: /*--------------------------------------------------------------+
3537: If more than one row in the BOM_INVENTORY_COMPS_INTERFACE
3538: that contain the same bill_sequence_id, operation_seq_num and
3539: component_item_id, those rows will be combined into a
3540: single row and the accumulated COMPONENT_QUANTITY will be
3541: used in the row.

Line 3551: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

3547: -- 4244576 - Also need to get operstion_seq_num into an array.
3548:
3549: select b1.model_comp_seq_id, b1.component_item_id, b1.operation_seq_num
3550: BULK COLLECT INTO model_comp_seq_id_arr, component_item_id_arr, operation_seq_num_arr
3551: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
3552: where b1.bill_sequence_id = b2.bill_sequence_id
3553: and b1.component_sequence_id <> b2.component_sequence_id
3554: and b1.operation_seq_num = b2.operation_seq_num
3555: and b1.component_item_id = b2.component_item_id

Line 3559: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

3555: and b1.component_item_id = b2.component_item_id
3556: and b1.bill_sequence_id = lConfigBillId
3557: UNION
3558: select b2.model_comp_seq_id, b2.component_item_id, b2.operation_seq_num
3559: from bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
3560: where b1.bill_sequence_id = b2.bill_sequence_id
3561: and b1.component_sequence_id <> b2.component_sequence_id
3562: and b1.operation_seq_num = b2.operation_seq_num
3563: and b1.component_item_id = b2.component_item_id

Line 3613: update bom_inventory_comps_interface

3609: *--------------------------------------------+
3610: different bill and not begining of the loop
3611: +--------------------------------------------*
3612: if lTotalQty <> 0 then
3613: update bom_inventory_comps_interface
3614: set component_quantity = Round( lTotalQty, 7) * Decimal-Qty Support for Option Items *
3615: where component_sequence_id = lSaveCompSeqId;
3616: end if;
3617:

Line 3619: update bom_inventory_comps_interface

3615: where component_sequence_id = lSaveCompSeqId;
3616: end if;
3617:
3618: if lSaveOptional = 1 then
3619: update bom_inventory_comps_interface
3620: set optional_on_model = lSaveOptional
3621: where component_sequence_id = lSaveCompSeqId;
3622: end if;
3623:

Line 3637: update bom_inventory_comps_interface

3633: *-----------------------------------------------+
3634: same bill but different item
3635: +------------------------------------------------*
3636: if lSaveItemId <> lItemId then
3637: update bom_inventory_comps_interface
3638: set component_quantity = Round( lTotalQty, 7 ) * Decimal-Qty Support for Option Items *
3639: where component_sequence_id = lSaveCompSeqId;
3640:
3641: if lSaveOptional = 1 then

Line 3642: update bom_inventory_comps_interface

3638: set component_quantity = Round( lTotalQty, 7 ) * Decimal-Qty Support for Option Items *
3639: where component_sequence_id = lSaveCompSeqId;
3640:
3641: if lSaveOptional = 1 then
3642: update bom_inventory_comps_interface
3643: set optional_on_model = lSaveOptional
3644: where component_sequence_id = lSaveCompSeqId;
3645: end if;
3646:

Line 3654: update bom_inventory_comps_interface

3650: same bill and item but different seq_num
3651: +---------------------------------------------*
3652: else
3653: if lSaveOpSeqNum <> lOpSeqNum then
3654: update bom_inventory_comps_interface
3655: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3656: where component_sequence_id = lSaveCompSeqId;
3657: lTotalQty := lqty;
3658:

Line 3660: update bom_inventory_comps_interface

3656: where component_sequence_id = lSaveCompSeqId;
3657: lTotalQty := lqty;
3658:
3659: if lSaveOptional = 1 then
3660: update bom_inventory_comps_interface
3661: set optional_on_model = lSaveOptional
3662: where component_sequence_id = lSaveCompSeqId;
3663: end if;
3664: lSaveOptional := lOptional;

Line 3669: delete bom_inventory_comps_interface

3665: *----------------------------------+
3666: duplicated one
3667: +----------------------------------*
3668: else
3669: delete bom_inventory_comps_interface
3670: where component_sequence_id = lSaveCompSeqId;
3671: lTotalQty := lTotalQty + lqty;
3672: if lOptional = 1 then
3673: lSaveOptional := 1;

Line 3691: update bom_inventory_comps_interface

3687: WriteToLog('Consolidate_components:lTotalQty: ' || to_char(lTotalQty), 5);
3688: WriteToLog('Consolidate_components:ComponentSeqID: ' || to_char(lSaveCompSeqId), 5);
3689:
3690: lStmtNum := 140;
3691: update bom_inventory_comps_interface
3692: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3693: where component_sequence_id = lSaveCompSeqId;
3694:
3695: if lSaveOptional = 1 then

Line 3696: update bom_inventory_comps_interface

3692: set component_quantity = Round( lTotalQty , 7 ) * Decimal-Qty Support for Option Items *
3693: where component_sequence_id = lSaveCompSeqId;
3694:
3695: if lSaveOptional = 1 then
3696: update bom_inventory_comps_interface
3697: set optional_on_model = lSaveOptional
3698: where component_sequence_id = lSaveCompSeqId;
3699: end if;
3700: close consolidate_components;

Line 3732: from bom_inventory_comps_interface

3728: WriteToLog( ' Looping for item id : ' ||club_comp_rec.item_id ||' operation_seq : '||club_comp_rec.operation_seq_num,1);
3729:
3730: select distinct effectivity_date
3731: BULK COLLECT INTO asc_date_arr
3732: from bom_inventory_comps_interface
3733: where bill_sequence_id = lConfigBillId
3734: and component_item_id = club_comp_rec.item_id
3735: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3736: UNION

Line 3738: from bom_inventory_comps_interface

3734: and component_item_id = club_comp_rec.item_id
3735: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3736: UNION
3737: select distinct disable_date
3738: from bom_inventory_comps_interface
3739: where bill_sequence_id = lConfigBillId
3740: and component_item_id = club_comp_rec.item_id
3741: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
3742: order by 1;

Line 3837: bom_inventory_comps_interface b1,bom_inventory_comps_interface b2

3833: select b1.model_comp_seq_id, b1.component_item_id
3834: BULK COLLECT INTO
3835: basis_model_comp_seq_id_arr, basis_component_item_id_arr
3836: from
3837: bom_inventory_comps_interface b1,bom_inventory_comps_interface b2
3838: where b1.bill_sequence_id = b2.bill_sequence_id
3839: and b1.component_sequence_id <> b2.component_sequence_id
3840: and b1.operation_seq_num = b2.operation_seq_num
3841: and b1.component_item_id = b2.component_item_id

Line 3925: from bom_inventory_comps_interface

3921:
3922: select max(rowid), sum(decode(basis_type, 1, component_quantity, 0))
3923: + max(decode(basis_type, 2, component_quantity, 0)) /* LBM Project */
3924: into club_tab_arr(x4).row_id,club_tab_arr(x4).qty
3925: from bom_inventory_comps_interface
3926: where effectivity_date <= club_tab_arr(x4).eff_dt
3927: and nvl(disable_date,g_SchShpDate) >= club_tab_arr(x4).dis_dt
3928: and bill_sequence_id = lConfigBillId
3929: and component_item_id = club_comp_rec.item_id

Line 3947: -- Now insert into bom_inventory_comps_interface

3943: END IF;
3944: end loop;
3945: end if;
3946:
3947: -- Now insert into bom_inventory_comps_interface
3948:
3949: if club_tab_arr.count > 0 then
3950:
3951: for x6 in club_tab_arr.FIRST.. club_tab_arr.LAST

Line 3954: insert into bom_inventory_comps_interface

3950:
3951: for x6 in club_tab_arr.FIRST.. club_tab_arr.LAST
3952: loop
3953: If nvl(club_tab_arr(x6).qty,0) <> 0 Then
3954: insert into bom_inventory_comps_interface
3955: (
3956: component_item_id,
3957: bill_sequence_id,
3958: effectivity_date,

Line 4087: from bom_inventory_comps_interface

4083: plan_level,
4084: revised_item_sequence_id
4085: , nvl(basis_type,1), /* LBM project */
4086: cto_msutil_pub.bom_batch_id
4087: from bom_inventory_comps_interface
4088: where component_item_id = club_comp_rec.item_id
4089: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4090: and bill_sequence_id = lConfigBillId
4091: and rowid = club_tab_arr(x6).row_id;

Line 4097: delete from bom_inventory_comps_interface

4093: end loop;
4094: end if;
4095:
4096: -- Delete original option item rows from bici
4097: delete from bom_inventory_comps_interface
4098: where component_item_id = club_comp_rec.item_id
4099: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4100: and bill_sequence_id = lConfigBillId
4101: and created_by <> lConfigBillId;

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

4099: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4100: and bill_sequence_id = lConfigBillId
4101: and created_by <> lConfigBillId;
4102:
4103: -- Delete rows from bom_inventory_comps_interface where qty = 0
4104: delete from bom_inventory_comps_interface
4105: where component_item_id = club_comp_rec.item_id
4106: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4107: and bill_sequence_id = lConfigBillId

Line 4104: delete from bom_inventory_comps_interface

4100: and bill_sequence_id = lConfigBillId
4101: and created_by <> lConfigBillId;
4102:
4103: -- Delete rows from bom_inventory_comps_interface where qty = 0
4104: delete from bom_inventory_comps_interface
4105: where component_item_id = club_comp_rec.item_id
4106: and operation_seq_num = club_comp_rec.operation_seq_num --4244576
4107: and bill_sequence_id = lConfigBillId
4108: and created_by = lConfigBillId

Line 4163: update bom_inventory_comps_interface

4159: p_item_num := p_item_num + p_seq_increment;
4160:
4161: WriteToLog('p_item_num::'||to_char(p_item_num), 5);
4162:
4163: update bom_inventory_comps_interface
4164: set item_num = p_item_num
4165: where bill_sequence_id = lConfigbillid and parent_bill_seq_id = 0; /* 04-04-2005 bugfix 3374548 */
4166:
4167:

Line 4182: from bom_inventory_comps_interface

4178: into p_bill_seq_id
4179: from bom_bill_of_materials
4180: where assembly_item_id =
4181: (select component_item_id
4182: from bom_inventory_comps_interface
4183: where bill_sequence_id = lConfigBillId and parent_bill_seq_id = 0) /* Introduced by sushant */
4184: and organization_id = pOrgId
4185: and alternate_bom_designator is null;
4186:

Line 4483: from bom_inventory_comps_interface b,

4479: b.parent_bill_seq_id, --isp bom
4480: b.plan_level, --isp bom
4481: b.model_comp_seq_id --isp bom
4482: , decode(b.basis_type,1,null,b.basis_type) /* LBM change */
4483: from bom_inventory_comps_interface b,
4484: mtl_system_items msi
4485: where b.bill_sequence_id = lConfigBillId
4486: and b.component_item_id = msi.inventory_item_id
4487: and msi.organization_id = pOrgId;

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

4593: ,creation_date
4594: ,created_by
4595: ,last_update_login
4596: */
4597: from bom_inventory_comps_interface b , bom_inventory_components bic, bom_substitute_components s
4598: where b.bill_sequence_id = lConfigBillId
4599: and ABS(b.model_comp_seq_id) = bic.component_sequence_id
4600: and bic.optional = 2 /* only mandatory components */
4601: and bic.component_sequence_id = s.component_sequence_id ;

Line 5074: /* Clean up bom_inventory_comps_interface */

5070: );
5071:
5072: lStmtNum := 380;
5073:
5074: /* Clean up bom_inventory_comps_interface */
5075:
5076: delete from bom_inventory_comps_interface
5077: where bill_sequence_id = lConfigBillId;
5078:

Line 5076: delete from bom_inventory_comps_interface

5072: lStmtNum := 380;
5073:
5074: /* Clean up bom_inventory_comps_interface */
5075:
5076: delete from bom_inventory_comps_interface
5077: where bill_sequence_id = lConfigBillId;
5078:
5079:
5080: return(1);

Line 5595: from bom_inventory_comps_interface

5591:
5592: CURSOR c_update_item_num(p_parent_bill_seq_id number) IS
5593: select component_sequence_id,
5594: component_item_id
5595: from bom_inventory_comps_interface
5596: where parent_bill_seq_id = p_parent_bill_seq_id
5597: FOR UPDATE OF item_num;
5598:
5599: p_bill_seq_id number;

Line 5611: update bom_inventory_comps_interface

5607:
5608: --
5609: -- update item_num of child of this model
5610: --
5611: update bom_inventory_comps_interface
5612: set item_num = p_item_num
5613: where current of c_update_item_num;
5614:
5615: WriteToLog('Updated item '||to_char(v_update_item_num.component_item_id)|| ' with item num '||to_char(p_item_num), 5);

Line 6312: insert into BOM_INVENTORY_COMPS_INTERFACE

6308:
6309: lStmtNumber := 550;
6310:
6311: /*Insert into bic interface*/
6312: insert into BOM_INVENTORY_COMPS_INTERFACE
6313: ( operation_seq_num,
6314: component_item_id,
6315: last_update_date,
6316: last_updated_by,

Line 6454: update bom_inventory_comps_interface

6450: where bill_sequence_id = pConfigBillId;
6451:
6452: lCnt := sql%rowcount ;
6453: WriteToLog('Inherit_op_seq_ml:Inserted in BIC Interface ' || lCnt ||' rows from BET', 4);
6454: update bom_inventory_comps_interface
6455: set disable_date = g_futuredate
6456: where (component_item_id, operation_seq_num,disable_date)
6457: in ( select
6458: component_item_id, operation_seq_num,max(disable_date)

Line 6459: from bom_inventory_comps_interface

6455: set disable_date = g_futuredate
6456: where (component_item_id, operation_seq_num,disable_date)
6457: in ( select
6458: component_item_id, operation_seq_num,max(disable_date)
6459: from bom_inventory_comps_interface
6460: where bill_sequence_id = pConfigBillId
6461: group by component_item_id, operation_seq_num, assembly_item_id
6462: )
6463: and bill_sequence_id = pConfigBillId

Line 6479: ( select * from bom_inventory_comps_interface

6475: begin
6476: select 1 into v_overlap_check
6477: from dual
6478: where exists
6479: ( select * from bom_inventory_comps_interface
6480: where bill_sequence_id = pConfigBillId
6481: group by component_item_id, assembly_item_id
6482: having count(distinct operation_seq_num) > 1
6483: );

Line 6500: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2

6496: BULK COLLECT INTO
6497: v_t_overlap_comp_item_id,
6498: v_t_overlap_src_op_seq_num, v_t_overlap_src_eff_date, v_t_overlap_src_disable_date ,
6499: v_t_overlap_dest_op_seq_num , v_t_overlap_dest_eff_date, v_t_overlap_dest_disable_date
6500: from bom_inventory_comps_interface s1 , bom_inventory_comps_interface s2
6501: where s1.component_item_id = s2.component_item_id and s1.assembly_item_id = s2.assembly_item_id
6502: and s1.effectivity_date between s2.effectivity_date and s2.disable_date
6503: and s1.component_sequence_id <> s2.component_sequence_id ;
6504: