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_BOM_RTG_PK dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 66: | Added delete from from bom_inventory_comps_interface to avoid corrupt data.

62: * Fixed Bug 3349142
63: * Added token to error message CTO_NO_BOM_CREATED_IN_ANY_ORGS
64: *
65: | ssawant 15-JAN-04 Bugfix 3374548
66: | Added delete from from bom_inventory_comps_interface to avoid corrupt data.
67: |
68: Modified on 21-APR-2004 By Renga Kannan ( Bug 3543547)
69: * Autocreate config is dropping
70: * components from bill

Line 427: added effectivity window condition for bom_inventory_comps_interface

423: /* bugfix 2986192 Cursor to select dropped items during match */
424: /* Effectivity date bug fix : 4147224
425: Need to validate the dropped component for Estimated relase date
426: window. Added a xEstRelDate parameter to cursor and
427: added effectivity window condition for bom_inventory_comps_interface
428: Sql
429: */
430:
431: cursor mismatched_items ( xlineid number,

Line 441: from bom_inventory_comps_interface

437: and parent_ato_line_id <> line_id /* to avoid selecting top model */
438: and NOT ( bom_item_type = 1 and wip_supply_type <> 6 and line_id <> xlineid ) /* to avoid selecting lower level models */
439: minus
440: select component_item_id
441: from bom_inventory_comps_interface
442: where bill_sequence_id = xconfigbillid
443: and greatest(sysdate, xEstRelDate ) >= effectivity_date
444: and (( disable_date is null ) or ( disable_date is not null and disable_date >= greatest(sysdate, xEstRelDate) )) ;
445:

Line 697: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,

693:
694: -- rkaza. bug 4524248. 11/09/2005.
695: -- bom structure import enhancements. Added batch_id.
696:
697: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
698: effectivity_date,disable_date)
699: select component_item_id, bill_sequence_id,
700: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
701: from bom_inventory_components

Line 729: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,

725: IF PG_DEBUG <> 0 THEN
726: oe_debug_pub.add('Inserting child base model into BICI for matched cases... ' ,1);
727: END IF;
728:
729: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,
730: effectivity_date,disable_date)
731: select distinct a.base_model_id, b.bill_sequence_id,
732: cto_msutil_pub.bom_batch_id,effectivity_date,disable_date
733: from bom_ato_configurations a,bom_inventory_components b

Line 742: oe_debug_pub.add('Failed to insert into bom_inventory_comps_interface with error '||sqlerrm);

738:
739: exception
740: when others then
741: IF PG_DEBUG <> 0 THEN
742: oe_debug_pub.add('Failed to insert into bom_inventory_comps_interface with error '||sqlerrm);
743: END IF;
744: raise fnd_api.g_exc_error;
745: end ;
746:

Line 1454: delete from bom_inventory_comps_interface

1450:
1451: lStmtNum := 116;
1452:
1453: -- 3543547 Replace lItmBillId with lComItmBillId
1454: delete from bom_inventory_comps_interface
1455: where bill_sequence_id = lComItmBillId
1456: and batch_id = cto_msutil_pub.bom_batch_id;
1457:
1458:

Line 1506: /* Clean up bom_inventory_comps_interface */

1502: IF PG_DEBUG <> 0 THEN
1503: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1504: END IF;
1505:
1506: /* Clean up bom_inventory_comps_interface */
1507: delete from bom_inventory_comps_interface
1508: where bill_sequence_id = lCfgBillId;
1509:
1510:

Line 1507: delete from bom_inventory_comps_interface

1503: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1504: END IF;
1505:
1506: /* Clean up bom_inventory_comps_interface */
1507: delete from bom_inventory_comps_interface
1508: where bill_sequence_id = lCfgBillId;
1509:
1510:
1511: if( lStatus = -1) then /* add a message for unexpected errors(-1), expected errors(0) already have a message */

Line 1556: /* Clean up bom_inventory_comps_interface */

1552: IF PG_DEBUG <> 0 THEN
1553: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1554: END IF;
1555:
1556: /* Clean up bom_inventory_comps_interface */
1557: delete from bom_inventory_comps_interface
1558: where bill_sequence_id = lCfgBillId;
1559:
1560: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ROUTING_ERROR');

Line 1557: delete from bom_inventory_comps_interface

1553: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1554: END IF;
1555:
1556: /* Clean up bom_inventory_comps_interface */
1557: delete from bom_inventory_comps_interface
1558: where bill_sequence_id = lCfgBillId;
1559:
1560: cto_msg_pub.cto_message('BOM', 'CTO_CREATE_ROUTING_ERROR');
1561: raise fnd_api.g_exc_error;

Line 1590: /* Clean up bom_inventory_comps_interface */

1586: oe_debug_pub.add('create_in_src_orgs: '
1587: || ' Failed in Create_bom_data', 1);
1588: END IF;
1589:
1590: /* Clean up bom_inventory_comps_interface */
1591: delete from bom_inventory_comps_interface
1592: where bill_sequence_id = lCfgBillId;
1593:
1594: if( lXMessageName is not null ) then

Line 1591: delete from bom_inventory_comps_interface

1587: || ' Failed in Create_bom_data', 1);
1588: END IF;
1589:
1590: /* Clean up bom_inventory_comps_interface */
1591: delete from bom_inventory_comps_interface
1592: where bill_sequence_id = lCfgBillId;
1593:
1594: if( lXMessageName is not null ) then
1595: xMsgData := lXMessageName ;