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 700: insert into bom_inventory_comps_interface(component_item_id,bill_sequence_id, batch_id,

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

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

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

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

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

Line 1457: delete from bom_inventory_comps_interface

1453:
1454: lStmtNum := 116;
1455:
1456: -- 3543547 Replace lItmBillId with lComItmBillId
1457: delete from bom_inventory_comps_interface
1458: where bill_sequence_id = lComItmBillId
1459: and batch_id = cto_msutil_pub.bom_batch_id;
1460:
1461: lCnt := sql%rowcount;

Line 1524: /* Clean up bom_inventory_comps_interface */

1520: IF PG_DEBUG <> 0 THEN
1521: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1522: END IF;
1523:
1524: /* Clean up bom_inventory_comps_interface */
1525: delete from bom_inventory_comps_interface
1526: where bill_sequence_id = lCfgBillId;
1527:
1528: lCnt := sql%rowcount;

Line 1525: delete from bom_inventory_comps_interface

1521: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in Create_bom.', 1);
1522: END IF;
1523:
1524: /* Clean up bom_inventory_comps_interface */
1525: delete from bom_inventory_comps_interface
1526: where bill_sequence_id = lCfgBillId;
1527:
1528: lCnt := sql%rowcount;
1529: IF PG_DEBUG <> 0 THEN

Line 1588: /* Clean up bom_inventory_comps_interface */

1584: IF PG_DEBUG <> 0 THEN
1585: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1586: END IF;
1587:
1588: /* Clean up bom_inventory_comps_interface */
1589: delete from bom_inventory_comps_interface
1590: where bill_sequence_id = lCfgBillId;
1591:
1592: lCnt := sql%rowcount;

Line 1589: delete from bom_inventory_comps_interface

1585: oe_debug_pub.add('create_in_src_orgs: ' || ' Failed in create_routing.');
1586: END IF;
1587:
1588: /* Clean up bom_inventory_comps_interface */
1589: delete from bom_inventory_comps_interface
1590: where bill_sequence_id = lCfgBillId;
1591:
1592: lCnt := sql%rowcount;
1593: IF PG_DEBUG <> 0 THEN

Line 1636: /* Clean up bom_inventory_comps_interface */

1632: oe_debug_pub.add('create_in_src_orgs: '
1633: || ' Failed in Create_bom_data', 1);
1634: END IF;
1635:
1636: /* Clean up bom_inventory_comps_interface */
1637: delete from bom_inventory_comps_interface
1638: where bill_sequence_id = lCfgBillId;
1639:
1640: lCnt := sql%rowcount;

Line 1637: delete from bom_inventory_comps_interface

1633: || ' Failed in Create_bom_data', 1);
1634: END IF;
1635:
1636: /* Clean up bom_inventory_comps_interface */
1637: delete from bom_inventory_comps_interface
1638: where bill_sequence_id = lCfgBillId;
1639:
1640: lCnt := sql%rowcount;
1641: IF PG_DEBUG <> 0 THEN