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

Line 884: FROM BOM_COMPONENTS_B

880: END IF;
881:
882: SELECT implementation_date
883: INTO l_impl_date
884: FROM BOM_COMPONENTS_B
885: WHERE component_sequence_id = p_orig_old_comp_seq;
886: --bug 9238945 changes begin
887: --if parent records is unimplemented, so would be the child one.
888: --infact there could be multiple umimplemented ecos on the child bill but corresponds to the same common_component_sequence_id

Line 891: select max(component_sequence_id) into l_comp_seq_id from BOM_COMPONENTS_B bic

887: --if parent records is unimplemented, so would be the child one.
888: --infact there could be multiple umimplemented ecos on the child bill but corresponds to the same common_component_sequence_id
889: --pick up the last one in the series, determined by the highest component_sequence_id
890: if l_impl_date is null then
891: select max(component_sequence_id) into l_comp_seq_id from BOM_COMPONENTS_B bic
892: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
893: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
894: AND bic.implementation_date is null;
895: else

Line 897: select count(*) into l_count from BOM_COMPONENTS_B bic

893: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
894: AND bic.implementation_date is null;
895: else
896:
897: select count(*) into l_count from BOM_COMPONENTS_B bic
898: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
899: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq;
900:
901: if l_count = 1 then

Line 902: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic

898: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
899: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq;
900:
901: if l_count = 1 then
902: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic
903: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
904: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq;
905: else
906: --last record in the line of changes

Line 907: select max(old_component_sequence_id) into old_comp_seq from BOM_COMPONENTS_B bic

903: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
904: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq;
905: else
906: --last record in the line of changes
907: select max(old_component_sequence_id) into old_comp_seq from BOM_COMPONENTS_B bic
908: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
909: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq;
910:
911: --if there are only 2 ecos one to create the component and another to change it, for example(both would have

Line 915: select count(*) into l_old_count from BOM_COMPONENTS_B bic

911: --if there are only 2 ecos one to create the component and another to change it, for example(both would have
912: --same old_component_sequence_id). In that case need to pick up the record with max
913: --component_sequence_id among these 2 records
914:
915: select count(*) into l_old_count from BOM_COMPONENTS_B bic
916: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
917: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
918: and bic.old_component_sequence_id = old_comp_seq;
919:

Line 921: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic

917: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
918: and bic.old_component_sequence_id = old_comp_seq;
919:
920: if l_old_count = 1 then
921: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic
922: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
923: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
924: and bic.old_component_sequence_id = old_comp_seq;
925: else

Line 926: select max(component_sequence_id) into l_comp_seq_id from BOM_COMPONENTS_B bic

922: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
923: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
924: and bic.old_component_sequence_id = old_comp_seq;
925: else
926: select max(component_sequence_id) into l_comp_seq_id from BOM_COMPONENTS_B bic
927: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
928: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq
929: and bic.old_component_sequence_id = old_comp_seq;
930: end if;

Line 937: FROM BOM_COMPONENTS_B bic

933: end if;
934:
935: SELECT component_sequence_id, wip_supply_type, supply_subinventory, supply_locator_id, include_in_cost_rollup, operation_seq_num
936: INTO x_old_comp_seq_id, x_wip_supply_type, x_wip_supply_subinv, x_wip_supply_locator_id, x_inc_in_cost_rollup, x_op_seq
937: FROM BOM_COMPONENTS_B bic
938: WHERE bic.component_sequence_id = l_comp_seq_id;
939: --bug 9238945 changes end
940:
941: /* SELECT component_sequence_id, wip_supply_type, supply_subinventory, supply_locator_id, include_in_cost_rollup, operation_seq_num

Line 943: FROM BOM_COMPONENTS_B bic

939: --bug 9238945 changes end
940:
941: /* SELECT component_sequence_id, wip_supply_type, supply_subinventory, supply_locator_id, include_in_cost_rollup, operation_seq_num
942: INTO x_old_comp_seq_id, x_wip_supply_type, x_wip_supply_subinv, x_wip_supply_locator_id, x_inc_in_cost_rollup, x_op_seq
943: FROM BOM_COMPONENTS_B bic
944: WHERE bic.bill_sequence_id = p_dest_bill_seq_id
945: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_orig_old_comp_seq --bic.old_component_sequence_id
946: AND (
947: (bic.implementation_date is not null

Line 979: FROM bom_components_b

975:
976: BEGIN
977: SELECT component_item_revision_id
978: INTO l_comp_rev_id
979: FROM bom_components_b
980: WHERE component_sequence_id = p_src_comp_seq_id;
981:
982: IF l_comp_rev_id IS NULL
983: THEN

Line 1016: from BOM_COMPONENTS_B

1012: IS
1013: Cursor get_source_components(p_bill_sequence_id Number)
1014: IS
1015: SELECT *
1016: from BOM_COMPONENTS_B
1017: where bill_sequence_id = p_bill_sequence_id;
1018:
1019: Cursor get_structure_type(p_bill_seq_id NUMBER)
1020: IS

Line 1029: FROM BOM_COMPONENTS_B

1025:
1026: Cursor get_dest_components(p_src_comp_seq_id IN NUMBER, p_dest_bill_sequence_id IN NUMBER)
1027: IS
1028: SELECT *
1029: FROM BOM_COMPONENTS_B
1030: WHERE common_component_sequence_id = p_src_comp_seq_id
1031: and component_sequence_id <> common_component_sequence_id
1032: AND bill_sequence_id = p_dest_bill_sequence_id;
1033:

Line 1133: /*insert into BOM_COMPONENTS_B()

1129: --comp_rec.wip_supply_type := null;
1130: --Cant create a record with null wip_supply_type
1131: comp_rec.supply_subinventory := null;
1132: end if;*/
1133: /*insert into BOM_COMPONENTS_B()
1134: values();*/
1135: INSERT INTO BOM_COMPONENTS_B
1136: ( SUPPLY_SUBINVENTORY
1137: , OPERATION_LEAD_TIME_PERCENT

Line 1135: INSERT INTO BOM_COMPONENTS_B

1131: comp_rec.supply_subinventory := null;
1132: end if;*/
1133: /*insert into BOM_COMPONENTS_B()
1134: values();*/
1135: INSERT INTO BOM_COMPONENTS_B
1136: ( SUPPLY_SUBINVENTORY
1137: , OPERATION_LEAD_TIME_PERCENT
1138: , REVISED_ITEM_SEQUENCE_ID
1139: , COST_FACTOR

Line 1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom

1290: , comp_rec.from_minor_revision_id
1291: , comp_rec.component_sequence_id
1292: , comp_rec.basis_type
1293: , decode(comp_rec.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(comp_rec.component_item_revision_id, l_dest_org_id))
1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1295: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1296: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1297: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id
1298: AND item.organization_id = l_dest_org_id

Line 1360: UPDATE BOM_COMPONENTS_B

1356: , x_wip_supply_subinv => destn_comp.supply_subinventory
1357: , x_wip_supply_locator_id => destn_comp.supply_locator_id
1358: , x_inc_in_cost_rollup => destn_comp.include_in_cost_rollup
1359: , x_op_seq => destn_comp.operation_seq_num);
1360: UPDATE BOM_COMPONENTS_B
1361: SET old_component_sequence_id = destn_comp.old_component_sequence_id,
1362: wip_supply_type = destn_comp.wip_supply_type,
1363: supply_subinventory = destn_comp.supply_subinventory,
1364: supply_locator_id = destn_comp.supply_locator_id,

Line 1464: From BOM_COMPONENTS_B

1460: and source_bill_sequence_id = p_src_bill_sequence_id;
1461:
1462: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS
1463: Select *
1464: From BOM_COMPONENTS_B
1465: where component_sequence_id = p_src_comp_seq_id;
1466:
1467: l_err_text VARCHAR2(2000);
1468: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 1507: FROM BOM_COMPONENTS_B

1503: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1504:
1505: SELECT operation_seq_num
1506: INTO l_operation_seq_num
1507: FROM BOM_COMPONENTS_B
1508: WHERE component_Sequence_id = p_src_comp_seq_id;
1509:
1510: Check_Comp_Fixed_Rev_Dtls(p_src_bill_seq_id => p_src_bill_seq_id
1511: , p_src_comp_seq_id => p_src_comp_seq_id

Line 1519: from mtl_system_items_kfv item, bom_components_b comp

1515: THEN
1516:
1517: SELECT concatenated_segments
1518: into l_comp_name
1519: from mtl_system_items_kfv item, bom_components_b comp
1520: where item.inventory_item_id = comp.pk1_value
1521: and item.organization_id = comp.pk2_value
1522: and comp.component_sequence_id = p_src_comp_seq_id;
1523:

Line 1581: INSERT INTO BOM_COMPONENTS_B

1577: src_comp_details.component_sequence_id := get_component_sequence;
1578:
1579: --Set the old_component_sequence ids, if any, to refer to comps in the same bill instead of source bill.
1580:
1581: INSERT INTO BOM_COMPONENTS_B
1582: ( SUPPLY_SUBINVENTORY
1583: , OPERATION_LEAD_TIME_PERCENT
1584: , REVISED_ITEM_SEQUENCE_ID
1585: , COST_FACTOR

Line 1781: UPDATE BOM_COMPONENTS_B

1777: , x_op_seq => src_comp_details.operation_seq_num);
1778:
1779: IF src_comp_details.old_component_sequence_id IS NOT NULL
1780: THEN
1781: UPDATE BOM_COMPONENTS_B
1782: SET old_component_sequence_id = src_comp_details.old_component_sequence_id,
1783: wip_supply_type = src_comp_details.wip_supply_type,
1784: supply_subinventory = src_comp_details.supply_subinventory,
1785: supply_locator_id = src_comp_details.supply_locator_id,

Line 1850: FROM BOM_COMPONENTS_B

1846: --Cannot have records with basis type as lot and supply type Phantom.
1847: BEGIN
1848: SELECT 'Y'
1849: INTO l_dummy
1850: FROM BOM_COMPONENTS_B
1851: WHERE wip_supply_type = 6
1852: AND basis_type = 2
1853: AND component_sequence_id = src_comp_details.component_sequence_id;
1854:

Line 1968: FROM BOM_COMPONENTS_B

1964: IS
1965:
1966: Cursor get_related_Components(p_src_comp_seq_id NUMBER) IS
1967: SELECT *
1968: FROM BOM_COMPONENTS_B
1969: WHERE common_component_sequence_id = p_src_comp_seq_id
1970: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID order by bill_sequence_id;
1971:
1972: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS

Line 1974: FROM BOM_COMPONENTS_B

1970: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID order by bill_sequence_id;
1971:
1972: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS
1973: SELECT *
1974: FROM BOM_COMPONENTS_B
1975: WHERE component_sequence_id = p_src_comp_seq_id;
1976:
1977: /*Cursor get_comp_on_same_bill(p_src_comp_seq_id NUMBER, p_dest_bill_seq_id NUMBER) IS
1978: SELECT *

Line 1979: FROM BOM_COMPONENTS_B

1975: WHERE component_sequence_id = p_src_comp_seq_id;
1976:
1977: /*Cursor get_comp_on_same_bill(p_src_comp_seq_id NUMBER, p_dest_bill_seq_id NUMBER) IS
1978: SELECT *
1979: FROM BOM_COMPONENTS_B
1980: WHERE common_component_sequence_id = p_src_comp_seq_id
1981: AND bill_sequence_id = p_dest_bill_seq_id
1982: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID;*/
1983:

Line 2005: select max(implementation_date) into b_impl_date from BOM_COMPONENTS_B bic

2001: --loop
2002:
2003: --pick up the last implemented component
2004:
2005: select max(implementation_date) into b_impl_date from BOM_COMPONENTS_B bic
2006: WHERE bic.bill_sequence_id = dest_comp.bill_sequence_id
2007: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
2008: AND bic.implementation_date is not null;
2009:

Line 2011: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic

2007: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
2008: AND bic.implementation_date is not null;
2009:
2010:
2011: select component_sequence_id into l_comp_seq_id from BOM_COMPONENTS_B bic
2012: WHERE bic.bill_sequence_id = dest_comp.bill_sequence_id
2013: AND bic.COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq_id
2014: AND bic.implementation_date = b_impl_date;
2015:

Line 2018: UPDATE BOM_COMPONENTS_B dest_cmpo

2014: AND bic.implementation_date = b_impl_date;
2015:
2016:
2017:
2018: UPDATE BOM_COMPONENTS_B dest_cmpo
2019: SET DISABLE_DATE = DECODE(src_comp.IMPLEMENTATION_DATE,
2020: NULL, src_comp.DISABLE_DATE,
2021: DECODE(DISABLE_DATE,
2022: NULL, src_comp.DISABLE_DATE,

Line 2066: FROM BOM_COMPONENTS_B

2062: )
2063: IS
2064: Cursor get_related_Components(p_src_comp_seq_id NUMBER) IS
2065: SELECT *
2066: FROM BOM_COMPONENTS_B
2067: WHERE common_component_sequence_id = p_src_comp_seq_id
2068: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID;
2069:
2070: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS

Line 2072: FROM BOM_COMPONENTS_B

2068: AND COMPONENT_SEQUENCE_ID <> COMMON_COMPONENT_SEQUENCE_ID;
2069:
2070: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS
2071: SELECT *
2072: FROM BOM_COMPONENTS_B
2073: WHERE component_sequence_id = p_src_comp_seq_id;
2074:
2075: l_return_status varchar2(80);
2076: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 2124: from mtl_system_items_kfv item, bom_components_b comp

2120: THEN
2121:
2122: SELECT concatenated_segments
2123: into l_comp_name
2124: from mtl_system_items_kfv item, bom_components_b comp
2125: where item.inventory_item_id = comp.pk1_value
2126: and item.organization_id = comp.pk2_value
2127: and comp.component_sequence_id = p_src_comp_seq_id;
2128:

Line 2148: UPDATE BOM_COMPONENTS_B dest_cmpo

2144: END IF;
2145:
2146: for dest_comp in get_related_Components(p_src_comp_seq_id)
2147: loop
2148: UPDATE BOM_COMPONENTS_B dest_cmpo
2149: SET REQUIRED_FOR_REVENUE = src_comp.required_for_revenue
2150: , HIGH_QUANTITY = src_comp.HIGH_QUANTITY
2151: /* , WIP_SUPPLY_TYPE = p_rev_component_rec.wip_supply_type
2152: , SUPPLY_LOCATOR_ID =

Line 2285: FROM BOM_COMPONENTS_B

2281: BEGIN
2282:
2283: SELECT basis_type
2284: INTO l_dummy
2285: FROM BOM_COMPONENTS_B
2286: WHERE component_sequence_id = dest_comp.component_sequence_id;
2287:
2288: SELECT 'Y'
2289: INTO l_dummy

Line 2290: FROM BOM_COMPONENTS_B

2286: WHERE component_sequence_id = dest_comp.component_sequence_id;
2287:
2288: SELECT 'Y'
2289: INTO l_dummy
2290: FROM BOM_COMPONENTS_B
2291: WHERE wip_supply_type = 6
2292: AND basis_type = 2
2293: AND component_sequence_id = dest_comp.component_sequence_id;
2294:

Line 2356: UPDATE BOM_COMPONENTS_B bic

2352: --If the update is of the editable attrs of a component in an editable common bill
2353:
2354: --When the WIP attrs for the old component are modified, the pending changes still referencing
2355: --the ECO on src bill should be synchronized with the same values.
2356: UPDATE BOM_COMPONENTS_B bic
2357: SET (wip_supply_type, supply_locator_id, supply_subinventory, operation_seq_num, include_in_cost_rollup) =
2358: (SELECT wip_supply_type, supply_locator_id, supply_subinventory, operation_seq_num, include_in_cost_rollup
2359: FROM BOM_COMPONENTS_B
2360: WHERE component_sequence_id = p_src_comp_Seq_id)

Line 2359: FROM BOM_COMPONENTS_B

2355: --the ECO on src bill should be synchronized with the same values.
2356: UPDATE BOM_COMPONENTS_B bic
2357: SET (wip_supply_type, supply_locator_id, supply_subinventory, operation_seq_num, include_in_cost_rollup) =
2358: (SELECT wip_supply_type, supply_locator_id, supply_subinventory, operation_seq_num, include_in_cost_rollup
2359: FROM BOM_COMPONENTS_B
2360: WHERE component_sequence_id = p_src_comp_Seq_id)
2361: WHERE old_component_sequence_id = p_src_comp_Seq_id
2362: AND implementation_date IS NULL
2363: AND nvl(common_component_sequence_id, component_sequence_id) <> component_sequence_id

Line 2497: FROM BOM_COMPONENTS_B comp, BOM_REFERENCE_DESIGNATORS ref_desg

2493: , ref_desg.attribute14
2494: , ref_desg.attribute15
2495: , ref_desg.Original_System_Reference
2496: , p_component_sequence_id
2497: FROM BOM_COMPONENTS_B comp, BOM_REFERENCE_DESIGNATORS ref_desg
2498: WHERE comp.component_sequence_id <> comp.common_component_sequence_id
2499: AND comp.common_component_sequence_id = ref_desg.component_sequence_id
2500: AND ref_desg.component_sequence_id = p_component_sequence_id
2501: AND NOT EXISTS

Line 2581: from BOM_COMPONENTS_B dest, BOM_COMPONENTS_B src

2577:
2578: Cursor get_destn_comps(p_comp_seq_id number)
2579: is
2580: select dest.component_sequence_id
2581: from BOM_COMPONENTS_B dest, BOM_COMPONENTS_B src
2582: where dest.component_sequence_id <> dest.common_component_sequence_id
2583: and dest.common_component_sequence_id = p_comp_seq_id
2584: and src.component_sequence_id = dest.common_component_sequence_id
2585: and ((src.implementation_date is null

Line 2743: from BOM_COMPONENTS_B

2739:
2740: Cursor get_destn_comps(p_comp_seq_id number)
2741: is
2742: select component_sequence_id
2743: from BOM_COMPONENTS_B
2744: where component_sequence_id <> common_component_sequence_id
2745: and common_component_sequence_id = p_comp_seq_id;
2746:
2747: BEGIN

Line 2854: from BOM_COMPONENTS_B

2850:
2851: Cursor get_destn_comps(p_comp_seq_id number)
2852: is
2853: select component_sequence_id
2854: from BOM_COMPONENTS_B
2855: where component_sequence_id <> common_component_sequence_id
2856: and common_component_sequence_id = p_component_sequence_id;
2857:
2858: l_return_status varchar2(80);

Line 2932: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp

2928: , Bom_Globals.Get_Prog_Id
2929: , sub_comp.Original_System_Reference
2930: , sub_comp.enforce_int_requirements
2931: , sub_comp.component_sequence_id
2932: FROM BOM_SUBSTITUTE_COMPONENTS sub_comp, BOM_COMPONENTS_B dest_comp
2933: WHERE dest_comp.component_Sequence_id <> dest_comp.common_component_sequence_id
2934: AND dest_comp.common_component_sequence_id = sub_comp.component_sequence_id
2935: AND sub_comp.component_sequence_id = p_component_sequence_id
2936: AND NOT EXISTS

Line 3016: from BOM_COMPONENTS_B dest, BOM_COMPONENTS_B src

3012:
3013: Cursor get_destn_comps(p_comp_seq_id number)
3014: is
3015: select dest.component_sequence_id
3016: from BOM_COMPONENTS_B dest, BOM_COMPONENTS_B src
3017: where dest.component_sequence_id <> dest.common_component_sequence_id
3018: and dest.common_component_sequence_id = p_comp_seq_id
3019: and src.component_sequence_id = dest.common_component_sequence_id
3020: and ((src.implementation_date is null

Line 3184: from BOM_COMPONENTS_B

3180:
3181: Cursor get_destn_comps(p_comp_seq_id number)
3182: is
3183: select component_sequence_id
3184: from BOM_COMPONENTS_B
3185: where component_sequence_id <> common_component_sequence_id
3186: and common_component_sequence_id = p_comp_seq_id;
3187:
3188: BEGIN

Line 3293: from BOM_COMPONENTS_B

3289:
3290: Cursor get_destn_comps(p_comp_seq_id number)
3291: is
3292: select *
3293: from BOM_COMPONENTS_B
3294: where component_sequence_id <> common_component_sequence_id
3295: and common_component_sequence_id = p_comp_seq_id;
3296:
3297: l_return_status varchar2(80);

Line 3329: FROM bom_component_operations bco, BOM_COMPONENTS_B bic

3325: loop
3326: BEGIN
3327: SELECT bco.operation_seq_num
3328: INTO l_dummy
3329: FROM bom_component_operations bco, BOM_COMPONENTS_B bic
3330: WHERE bco.component_sequence_id = bic.component_sequence_id
3331: AND bic.component_sequence_id = p_component_sequence_id
3332: AND EXISTS(
3333: SELECT operation_seq_num, bos.routing_sequence_id

Line 3417: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp

3413: comp_ops.ATTRIBUTE13 ,
3414: comp_ops.ATTRIBUTE14 ,
3415: comp_ops.ATTRIBUTE15 ,
3416: comp_ops.COMPONENT_SEQUENCE_ID
3417: FROM BOM_COMPONENT_OPERATIONS comp_ops, BOM_COMPONENTS_B dest_comp
3418: WHERE dest_comp.component_Sequence_id <> dest_comp.common_component_sequence_id
3419: AND dest_comp.common_component_sequence_id = comp_ops.component_sequence_id
3420: AND comp_ops.component_sequence_id = p_component_sequence_id
3421: AND NOT EXISTS

Line 3500: from BOM_COMPONENTS_B

3496:
3497: Cursor get_destn_comps(p_comp_seq_id number)
3498: is
3499: select component_sequence_id, bill_sequence_id
3500: from BOM_COMPONENTS_B
3501: where component_sequence_id <> common_component_sequence_id
3502: and common_component_sequence_id = p_comp_seq_id;
3503:
3504: BEGIN

Line 3645: from BOM_COMPONENTS_B

3641:
3642: Cursor get_destn_comps(p_comp_seq_id number)
3643: is
3644: select component_sequence_id
3645: from BOM_COMPONENTS_B
3646: where component_sequence_id <> common_component_sequence_id
3647: and common_component_sequence_id = p_comp_seq_id;
3648:
3649: BEGIN

Line 3783: From BOM_COMPONENTS_B

3779:
3780: Cursor get_src_op_seq(p_src_bill_sequence_id NUMBER)
3781: IS
3782: Select OPERATION_SEQ_NUM
3783: From BOM_COMPONENTS_B
3784: Where bill_sequence_id = p_src_bill_sequence_id;
3785:
3786: /* Cursor get_primary_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3787: IS

Line 3929: from BOM_COMPONENTS_B

3925: Cursor get_source_and_dest_components(p_bill_sequence_id Number)
3926: IS
3927: SELECT
3928: component_sequence_id, common_component_sequence_id
3929: from BOM_COMPONENTS_B
3930: where bill_sequence_id = p_bill_sequence_id
3931: and component_sequence_id <> common_component_sequence_id;
3932:
3933: Cursor get_structure_type(p_bill_seq_id NUMBER)

Line 4044: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb

4040:
4041: Cursor get_dest_comps(p_src_comp_seq_id NUMBER, p_str_type_id NUMBER)
4042: IS
4043: SELECT bcb.component_sequence_id, bcb.bill_sequence_id
4044: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb
4045: WHERE bcb.common_component_sequence_id = p_src_comp_seq_id
4046: AND bcb.common_component_sequence_id <> bcb.component_sequence_id
4047: AND bsb.structure_type_id = p_str_type_id
4048: AND bsb.bill_sequence_id = bcb.bill_sequence_id

Line 4067: from BOM_COMPONENTS_B

4063:
4064: BEGIN
4065: SELECT bill_sequence_id
4066: into l_src_bill_seq_id
4067: from BOM_COMPONENTS_B
4068: where component_sequence_id = p_src_comp_seq_id;
4069:
4070: Open get_structure_type(p_bill_seq_id => l_src_bill_seq_id);
4071: Fetch get_structure_type into l_src_str_type;

Line 4289: DELETE FROM BOM_COMPONENTS_B

4285: IS
4286: BEGIN
4287:
4288: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('In Delete_Related_Components' ); END IF;
4289: DELETE FROM BOM_COMPONENTS_B
4290: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq;
4291:
4292: DELETE FROM BOM_REFERENCE_DESIGNATORS
4293: WHERE COMMON_COMPONENT_SEQUENCE_ID = p_src_comp_seq;

Line 4388: FROM BOM_COMPONENTS_B bic

4384: THEN
4385:
4386: SELECT 1
4387: INTO l_dummy
4388: FROM BOM_COMPONENTS_B bic
4389: WHERE bill_sequence_id = p_dest_bill_sequence_id
4390: AND component_sequence_id <> p_dest_comp_seq_id
4391: AND component_item_id = p_comp_item_id
4392: AND operation_seq_num = p_op_seq_num

Line 4419: FROM BOM_COMPONENTS_B bic

4415: ;
4416: ELSE
4417: SELECT 1
4418: INTO l_dummy
4419: FROM BOM_COMPONENTS_B bic
4420: WHERE bill_sequence_id = p_dest_bill_sequence_id
4421: AND component_sequence_id <> p_dest_comp_seq_id
4422: AND component_item_id = p_comp_item_id
4423: AND operation_seq_num = p_op_seq_num

Line 4467: FROM BOM_COMPONENTS_B

4463: BEGIN
4464:
4465: /* SELECT implementation_date
4466: INTO l_impl_date
4467: FROM BOM_COMPONENTS_B
4468: where component_sequence_id = p_src_comp_seq_id;
4469:
4470: IF l_impl_date IS NOT NULL
4471: THEN

Line 4477: DELETE BOM_COMPONENTS_B

4473: RETURN;
4474: END IF;
4475: */
4476: --Commented
4477: DELETE BOM_COMPONENTS_B
4478: WHERE common_component_sequence_id = p_src_comp_seq_id;
4479:
4480: DELETE BOM_SUBSTITUTE_COMPONENTS
4481: WHERE common_component_sequence_id = p_src_comp_seq_id;

Line 4543: FROM bom_components_b bcb

4539: --
4540: CURSOR c_pending_components ( cp_old_component_sequence_id NUMBER
4541: , cp_bill_sequence_id NUMBER ) IS
4542: SELECT *
4543: FROM bom_components_b bcb
4544: WHERE bcb.old_component_sequence_id = cp_old_component_sequence_id
4545: AND bcb.bill_sequence_id = cp_bill_sequence_id
4546: AND bcb.implementation_date IS NULL
4547: -- The following exists clause is to ensure that the pending component is not a source

Line 4561: FROM bom_components_b bcb

4557: -- for the change in the soruce bill
4558: --
4559: CURSOR c_related_components IS
4560: SELECT bcb.component_sequence_id, old_component_sequence_id, bill_sequence_id, effectivity_date
4561: FROM bom_components_b bcb
4562: WHERE bcb.change_notice = p_change_notice
4563: AND bcb.revised_item_sequence_id = p_revised_item_sequence_id
4564: AND bcb.common_component_sequence_id = p_src_comp_seq_id
4565: AND bcb.common_component_sequence_id <> bcb.component_sequence_id

Line 4569: l_component_rec bom_components_b%ROWTYPE;

4565: AND bcb.common_component_sequence_id <> bcb.component_sequence_id
4566: AND bcb.implementation_date IS NULL;
4567:
4568:
4569: l_component_rec bom_components_b%ROWTYPE;
4570: l_dest_new_comp_seq_id NUMBER;
4571: l_old_rev_item_seq_id NUMBER;
4572: l_gen_rev_item_seq_id NUMBER;
4573: l_return_status VARCHAR2(1);

Line 4644: INSERT INTO BOM_COMPONENTS_B

4640: l_component_rec.program_application_id := FND_PROFILE.value('RESP_APPL_ID');
4641: l_component_rec.program_id := FND_PROFILE.value('PROGRAM_ID');
4642: l_component_rec.program_update_date := sysdate;
4643:
4644: INSERT INTO BOM_COMPONENTS_B
4645: ( SUPPLY_SUBINVENTORY
4646: , OPERATION_LEAD_TIME_PERCENT
4647: , REVISED_ITEM_SEQUENCE_ID
4648: , COST_FACTOR

Line 4835: FROM bom_components_b

4831: BEGIN
4832:
4833: SELECT count(*)
4834: INTO l_comp_count
4835: FROM bom_components_b
4836: WHERE bill_sequence_id = p_src_bill_seq_id
4837: AND COMPONENT_ITEM_REVISION_ID IS NOT NULL;
4838:
4839: IF l_comp_count > 0

Line 4846: FROM BOM_COMPONENTS_B

4842: INTO l_rev_count
4843: FROM MTL_ITEM_REVISIONS_B source, MTL_ITEM_REVISIONS_B dest
4844: WHERE source.inventory_item_id = dest.inventory_item_id
4845: AND source.revision_id IN (SELECT COMPONENT_ITEM_REVISION_ID
4846: FROM BOM_COMPONENTS_B
4847: WHERE BILL_SEQUENCE_ID = p_src_bill_seq_id)
4848: AND dest.organization_id = p_org_id
4849: AND source.revision = dest.revision;
4850: