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.BOM_COPY_BILL dependencies on MTL_SYSTEM_ITEMS

Line 708: FROM mtl_system_items cmsi,

704: AND bom.common_bill_sequence_id = to_sequence_id
705: AND bic.bill_sequence_id = to_sequence_id
706: AND NOT EXISTS (
707: SELECT NULL
708: FROM mtl_system_items cmsi,
709: mtl_system_items bmsi
710: WHERE cmsi.organization_id = bom.organization_id
711: AND cmsi.inventory_item_id =
712: bic.component_item_id

Line 709: mtl_system_items bmsi

705: AND bic.bill_sequence_id = to_sequence_id
706: AND NOT EXISTS (
707: SELECT NULL
708: FROM mtl_system_items cmsi,
709: mtl_system_items bmsi
710: WHERE cmsi.organization_id = bom.organization_id
711: AND cmsi.inventory_item_id =
712: bic.component_item_id
713: AND bmsi.organization_id = bom.organization_id

Line 802: FROM mtl_system_items_b_kfv

798: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
799: IS
800: SELECT concatenated_segments,
801: primary_uom_code
802: FROM mtl_system_items_b_kfv
803: WHERE inventory_item_id = p_item_id
804: AND organization_id = p_org_id;
805:
806: CURSOR getcurrentminorrevcode (

Line 848: mtl_system_items msi

844: SELECT bic.component_sequence_id,
845: bic.component_item_id,
846: bic.operation_seq_num
847: FROM bom_inventory_components bic,
848: mtl_system_items msi
849: WHERE bic.bill_sequence_id = p_from_sequence_id
850: AND bic.component_item_id = msi.inventory_item_id
851: AND bic.component_item_id <> p_to_item_id
852: AND NVL (bic.eco_for_production, 2) = 2

Line 1117: FROM mtl_system_items

1113: rto_flag,
1114: base_item_flag,
1115: itm_type,
1116: itm_cat_grp_id
1117: FROM mtl_system_items
1118: WHERE organization_id = to_org_id
1119: AND inventory_item_id = to_item_id;
1120:
1121: sql_stmt_num := 18;

Line 1682: mtl_system_items msi,

1678: ELSE
1679: to_number(NULL)
1680: END AS to_minor_revision_id
1681: FROM bom_components_b bic,
1682: mtl_system_items msi,
1683: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
1684: bom_copy_explosions_v bev
1685: WHERE bic.bill_sequence_id = x_from_sequence_id
1686: AND bic.component_item_id = msi.inventory_item_id

Line 1683: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

1679: to_number(NULL)
1680: END AS to_minor_revision_id
1681: FROM bom_components_b bic,
1682: mtl_system_items msi,
1683: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
1684: bom_copy_explosions_v bev
1685: WHERE bic.bill_sequence_id = x_from_sequence_id
1686: AND bic.component_item_id = msi.inventory_item_id
1687: AND bic.component_item_id <> to_item_id

Line 1748: mtl_system_items_b msibs -- to assembly item

1744: SELECT 1
1745: FROM fnd_lookup_values_vl flv,
1746: ego_criteria_templates_v ectv,
1747: ego_criteria_v ecv,
1748: mtl_system_items_b msibs -- to assembly item
1749: WHERE ecv.customization_application_id = 702
1750: AND ecv.region_application_id = 702
1751: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
1752: AND ecv.customization_code = ectv.customization_code

Line 1773: mtl_system_items_b msibs -- to assembly item

1769: (
1770: SELECT 1
1771: FROM fnd_lookup_values_vl flv,
1772: ego_criteria_templates_v ectv,
1773: mtl_system_items_b msibs -- to assembly item
1774: WHERE flv.lookup_type = 'ITEM_TYPE'
1775: AND flv.enabled_flag = 'Y'
1776: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
1777: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 2081: mtl_system_items msi,

2077: ELSE
2078: to_number(NULL)
2079: END AS to_minor_revision_id
2080: FROM bom_components_b bic,
2081: mtl_system_items msi,
2082: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2083: bom_copy_explosions_v bev
2084: WHERE bic.bill_sequence_id = x_from_sequence_id
2085: AND bic.component_item_id = msi.inventory_item_id

Line 2082: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

2078: to_number(NULL)
2079: END AS to_minor_revision_id
2080: FROM bom_components_b bic,
2081: mtl_system_items msi,
2082: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2083: bom_copy_explosions_v bev
2084: WHERE bic.bill_sequence_id = x_from_sequence_id
2085: AND bic.component_item_id = msi.inventory_item_id
2086: AND bic.component_item_id <> to_item_id

Line 2148: mtl_system_items_b msibs -- to assembly item

2144: SELECT 1
2145: FROM fnd_lookup_values_vl flv,
2146: ego_criteria_templates_v ectv,
2147: ego_criteria_v ecv,
2148: mtl_system_items_b msibs -- to assembly item
2149: WHERE ecv.customization_application_id = 702
2150: AND ecv.region_application_id = 702
2151: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
2152: AND ecv.customization_code = ectv.customization_code

Line 2173: mtl_system_items_b msibs -- to assembly item

2169: (
2170: SELECT 1
2171: FROM fnd_lookup_values_vl flv,
2172: ego_criteria_templates_v ectv,
2173: mtl_system_items_b msibs -- to assembly item
2174: WHERE flv.lookup_type = 'ITEM_TYPE'
2175: AND flv.enabled_flag = 'Y'
2176: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2177: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 2558: mtl_system_items msi,

2554: ELSE
2555: to_number(NULL)
2556: END AS to_minor_revision_id
2557: FROM bom_components_b bic,
2558: mtl_system_items msi,
2559: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2560: bom_copy_explosions_v bev
2561: WHERE bic.bill_sequence_id = x_from_sequence_id
2562: AND bic.component_item_id = msi.inventory_item_id

Line 2559: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

2555: to_number(NULL)
2556: END AS to_minor_revision_id
2557: FROM bom_components_b bic,
2558: mtl_system_items msi,
2559: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
2560: bom_copy_explosions_v bev
2561: WHERE bic.bill_sequence_id = x_from_sequence_id
2562: AND bic.component_item_id = msi.inventory_item_id
2563: AND bic.component_item_id <> to_item_id

Line 2625: mtl_system_items_b msibs -- to assembly item

2621: SELECT 1
2622: FROM fnd_lookup_values_vl flv,
2623: ego_criteria_templates_v ectv,
2624: ego_criteria_v ecv,
2625: mtl_system_items_b msibs -- to assembly item
2626: WHERE ecv.customization_application_id = 702
2627: AND ecv.region_application_id = 702
2628: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
2629: AND ecv.customization_code = ectv.customization_code

Line 2650: mtl_system_items_b msibs -- to assembly item

2646: (
2647: SELECT 1
2648: FROM fnd_lookup_values_vl flv,
2649: ego_criteria_templates_v ectv,
2650: mtl_system_items_b msibs -- to assembly item
2651: WHERE flv.lookup_type = 'ITEM_TYPE'
2652: AND flv.enabled_flag = 'Y'
2653: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
2654: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 3000: mtl_system_items msi,

2996: ELSE
2997: to_number(NULL)
2998: END AS to_minor_revision_id
2999: FROM bom_components_b bic,
3000: mtl_system_items msi,
3001: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3002: bom_copy_explosions_v bev
3003: WHERE bic.bill_sequence_id = x_from_sequence_id
3004: AND bic.component_item_id = msi.inventory_item_id

Line 3001: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

2997: to_number(NULL)
2998: END AS to_minor_revision_id
2999: FROM bom_components_b bic,
3000: mtl_system_items msi,
3001: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3002: bom_copy_explosions_v bev
3003: WHERE bic.bill_sequence_id = x_from_sequence_id
3004: AND bic.component_item_id = msi.inventory_item_id
3005: AND bic.component_item_id <> to_item_id

Line 3066: mtl_system_items_b msibs -- to assembly item

3062: SELECT 1
3063: FROM fnd_lookup_values_vl flv,
3064: ego_criteria_templates_v ectv,
3065: ego_criteria_v ecv,
3066: mtl_system_items_b msibs -- to assembly item
3067: WHERE ecv.customization_application_id = 702
3068: AND ecv.region_application_id = 702
3069: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
3070: AND ecv.customization_code = ectv.customization_code

Line 3091: mtl_system_items_b msibs -- to assembly item

3087: (
3088: SELECT 1
3089: FROM fnd_lookup_values_vl flv,
3090: ego_criteria_templates_v ectv,
3091: mtl_system_items_b msibs -- to assembly item
3092: WHERE flv.lookup_type = 'ITEM_TYPE'
3093: AND flv.enabled_flag = 'Y'
3094: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3095: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 3449: mtl_system_items msi,

3445: ELSE
3446: to_number(NULL)
3447: END AS to_minor_revision_id
3448: FROM bom_components_b bic,
3449: mtl_system_items msi,
3450: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3451: bom_copy_explosions_v bev
3452: WHERE bic.bill_sequence_id = x_from_sequence_id
3453: AND bic.component_item_id = msi.inventory_item_id

Line 3450: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

3446: to_number(NULL)
3447: END AS to_minor_revision_id
3448: FROM bom_components_b bic,
3449: mtl_system_items msi,
3450: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
3451: bom_copy_explosions_v bev
3452: WHERE bic.bill_sequence_id = x_from_sequence_id
3453: AND bic.component_item_id = msi.inventory_item_id
3454: AND bic.component_item_id <> to_item_id

Line 3517: mtl_system_items_b msibs -- to assembly item

3513: SELECT 1
3514: FROM fnd_lookup_values_vl flv,
3515: ego_criteria_templates_v ectv,
3516: ego_criteria_v ecv,
3517: mtl_system_items_b msibs -- to assembly item
3518: WHERE ecv.customization_application_id = 702
3519: AND ecv.region_application_id = 702
3520: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
3521: AND ecv.customization_code = ectv.customization_code

Line 3542: mtl_system_items_b msibs -- to assembly item

3538: (
3539: SELECT 1
3540: FROM fnd_lookup_values_vl flv,
3541: ego_criteria_templates_v ectv,
3542: mtl_system_items_b msibs -- to assembly item
3543: WHERE flv.lookup_type = 'ITEM_TYPE'
3544: AND flv.enabled_flag = 'Y'
3545: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
3546: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 3755: mtl_system_items_b_kfv msbk1,

3751:
3752: SELECT COUNT (*)
3753: INTO l_no_access_comp_cnt
3754: FROM bom_components_b bcb,
3755: mtl_system_items_b_kfv msbk1,
3756: bom_copy_explosions_v bev
3757: WHERE bcb.bill_sequence_id = x_from_sequence_id
3758: AND bcb.component_item_id = msbk1.inventory_item_id
3759: AND bcb.component_item_id <> to_item_id

Line 3842: FROM mtl_system_items_b_kfv msbk1

3838: fnd_global.conc_request_id,
3839: NULL,
3840: fnd_global.conc_program_id,
3841: sysdate
3842: FROM mtl_system_items_b_kfv msbk1
3843: WHERE msbk1.inventory_item_id = from_item_id
3844: AND msbk1.organization_id = from_org_id;
3845: END IF;
3846:

Line 3852: mtl_system_items_b_kfv msbk1,

3848: THEN
3849: SELECT COUNT (*)
3850: INTO l_no_access_comp_cnt
3851: FROM bom_components_b bcb,
3852: mtl_system_items_b_kfv msbk1,
3853: bom_copy_explosions_v bev
3854: WHERE bcb.bill_sequence_id = x_from_sequence_id
3855: AND bcb.component_item_id = msbk1.inventory_item_id
3856: AND bcb.component_item_id <> to_item_id

Line 3939: FROM mtl_system_items_b_kfv msbk1

3935: fnd_global.conc_request_id,
3936: NULL,
3937: fnd_global.conc_program_id,
3938: sysdate
3939: FROM mtl_system_items_b_kfv msbk1
3940: WHERE msbk1.inventory_item_id = from_item_id
3941: AND msbk1.organization_id = from_org_id;
3942: END IF;
3943: END IF;

Line 3987: mtl_system_items_b msib, -- component

3983: NULL,
3984: fnd_global.conc_program_id,
3985: sysdate
3986: FROM bom_components_b bcb,
3987: mtl_system_items_b msib, -- component
3988: bom_copy_explosions_v bev
3989: WHERE bcb.bill_sequence_id = x_from_sequence_id
3990: AND bcb.component_item_id = msib.inventory_item_id
3991: AND bcb.component_item_id <> to_item_id

Line 4158: mtl_system_items_b_kfv msbk1,

4154: SYSDATE,
4155: user_id,
4156: 'E'
4157: FROM bom_components_b bcb,
4158: mtl_system_items_b_kfv msbk1,
4159: mtl_system_items_b_kfv msbk2,
4160: bom_copy_explosions_v bev
4161: WHERE bcb.bill_sequence_id = x_from_sequence_id
4162: AND bcb.component_item_id = msbk1.inventory_item_id

Line 4159: mtl_system_items_b_kfv msbk2,

4155: user_id,
4156: 'E'
4157: FROM bom_components_b bcb,
4158: mtl_system_items_b_kfv msbk1,
4159: mtl_system_items_b_kfv msbk2,
4160: bom_copy_explosions_v bev
4161: WHERE bcb.bill_sequence_id = x_from_sequence_id
4162: AND bcb.component_item_id = msbk1.inventory_item_id
4163: AND bcb.component_item_id <> to_item_id

Line 4215: mtl_system_items_b msib,

4211: NULL,
4212: fnd_global.conc_program_id,
4213: sysdate
4214: FROM bom_components_b bcb,
4215: mtl_system_items_b msib,
4216: bom_copy_explosions_v bev
4217: WHERE bcb.bill_sequence_id = x_from_sequence_id
4218: AND bcb.component_item_id = msib.inventory_item_id
4219: AND bcb.component_item_id <> to_item_id

Line 4398: mtl_system_items_b msib

4394: NULL,
4395: fnd_global.conc_program_id,
4396: sysdate
4397: FROM bom_components_b bcb,
4398: mtl_system_items_b msib
4399: WHERE bcb.bill_sequence_id = to_sequence_id
4400: AND bcb.component_item_id = msib.inventory_item_id
4401: AND msib.organization_id = to_org_id
4402: AND 'Y' <>

Line 4463: mtl_system_items_b msib

4459: NULL,
4460: fnd_global.conc_program_id,
4461: sysdate
4462: FROM bom_components_b bcb,
4463: mtl_system_items_b msib
4464: WHERE bcb.bill_sequence_id = to_sequence_id
4465: AND bcb.component_item_id = msib.inventory_item_id
4466: AND msib.organization_id = to_org_id
4467: AND 'Y' <>

Line 4814: mtl_system_items msi,

4810: bic.vendor_id,
4811: bic.unit_price,
4812: bic.basis_type
4813: FROM bom_inventory_components bic,
4814: mtl_system_items msi,
4815: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
4816: WHERE bic.bill_sequence_id = x_from_sequence_id
4817: AND bic.component_item_id = msi.inventory_item_id
4818: AND bic.component_item_id <> to_item_id

Line 4815: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185

4811: bic.unit_price,
4812: bic.basis_type
4813: FROM bom_inventory_components bic,
4814: mtl_system_items msi,
4815: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
4816: WHERE bic.bill_sequence_id = x_from_sequence_id
4817: AND bic.component_item_id = msi.inventory_item_id
4818: AND bic.component_item_id <> to_item_id
4819: AND NVL (bic.eco_for_production, 2) = 2

Line 5171: mtl_system_items_b msib1,

5167: NULL,
5168: fnd_global.conc_program_id,
5169: sysdate
5170: FROM bom_components_b bcb,
5171: mtl_system_items_b msib1,
5172: mtl_system_items_b msib2
5173: WHERE bcb.bill_sequence_id = to_sequence_id
5174: AND (msib1.bom_item_type = planning
5175: AND msib2.bom_item_type <> planning

Line 5172: mtl_system_items_b msib2

5168: fnd_global.conc_program_id,
5169: sysdate
5170: FROM bom_components_b bcb,
5171: mtl_system_items_b msib1,
5172: mtl_system_items_b msib2
5173: WHERE bcb.bill_sequence_id = to_sequence_id
5174: AND (msib1.bom_item_type = planning
5175: AND msib2.bom_item_type <> planning
5176: )

Line 5224: mtl_system_items_b msib1,

5220: NULL,
5221: fnd_global.conc_program_id,
5222: sysdate
5223: FROM bom_components_b bcb,
5224: mtl_system_items_b msib1,
5225: mtl_system_items_b msib2
5226: WHERE bcb.bill_sequence_id = to_sequence_id
5227: AND (msib1.bom_item_type IN (model, option_class)
5228: AND msib2.bom_item_type = STANDARD

Line 5225: mtl_system_items_b msib2

5221: fnd_global.conc_program_id,
5222: sysdate
5223: FROM bom_components_b bcb,
5224: mtl_system_items_b msib1,
5225: mtl_system_items_b msib2
5226: WHERE bcb.bill_sequence_id = to_sequence_id
5227: AND (msib1.bom_item_type IN (model, option_class)
5228: AND msib2.bom_item_type = STANDARD
5229: AND msib2.base_item_id IS NULL

Line 5278: mtl_system_items_b msib1, -- Comp

5274: NULL,
5275: fnd_global.conc_program_id,
5276: sysdate
5277: FROM bom_components_b bcb,
5278: mtl_system_items_b msib1, -- Comp
5279: mtl_system_items_b msib2 -- Structure
5280: WHERE bcb.bill_sequence_id = to_sequence_id
5281: AND (msib1.replenish_to_order_flag = 'Y'
5282: AND msib1.bom_item_type = option_class

Line 5279: mtl_system_items_b msib2 -- Structure

5275: fnd_global.conc_program_id,
5276: sysdate
5277: FROM bom_components_b bcb,
5278: mtl_system_items_b msib1, -- Comp
5279: mtl_system_items_b msib2 -- Structure
5280: WHERE bcb.bill_sequence_id = to_sequence_id
5281: AND (msib1.replenish_to_order_flag = 'Y'
5282: AND msib1.bom_item_type = option_class
5283: AND msib2.pick_components_flag = 'Y'

Line 5332: mtl_system_items_b msib1, -- Comp

5328: NULL,
5329: fnd_global.conc_program_id,
5330: sysdate
5331: FROM bom_components_b bcb,
5332: mtl_system_items_b msib1, -- Comp
5333: mtl_system_items_b msib2 -- Structure
5334: WHERE bcb.bill_sequence_id = to_sequence_id
5335: AND (msib1.replenish_to_order_flag = 'Y'
5336: AND msib1.bom_item_type = STANDARD

Line 5333: mtl_system_items_b msib2 -- Structure

5329: fnd_global.conc_program_id,
5330: sysdate
5331: FROM bom_components_b bcb,
5332: mtl_system_items_b msib1, -- Comp
5333: mtl_system_items_b msib2 -- Structure
5334: WHERE bcb.bill_sequence_id = to_sequence_id
5335: AND (msib1.replenish_to_order_flag = 'Y'
5336: AND msib1.bom_item_type = STANDARD
5337: AND msib2.pick_components_flag = 'Y'

Line 5387: mtl_system_items_b msib1, -- Comp

5383: NULL,
5384: fnd_global.conc_program_id,
5385: sysdate
5386: FROM bom_components_b bcb,
5387: mtl_system_items_b msib1, -- Comp
5388: mtl_system_items_b msib2 -- Structure
5389: WHERE bcb.bill_sequence_id = to_sequence_id
5390: AND (msib1.pick_components_flag = 'Y'
5391: AND msib2.replenish_to_order_flag = 'Y'

Line 5388: mtl_system_items_b msib2 -- Structure

5384: fnd_global.conc_program_id,
5385: sysdate
5386: FROM bom_components_b bcb,
5387: mtl_system_items_b msib1, -- Comp
5388: mtl_system_items_b msib2 -- Structure
5389: WHERE bcb.bill_sequence_id = to_sequence_id
5390: AND (msib1.pick_components_flag = 'Y'
5391: AND msib2.replenish_to_order_flag = 'Y'
5392: )

Line 5405: FROM mtl_system_items msi1, -- bom

5401: DELETE FROM bom_inventory_components bic
5402: WHERE bic.bill_sequence_id = to_sequence_id
5403: AND EXISTS (
5404: SELECT NULL
5405: FROM mtl_system_items msi1, -- bom
5406: mtl_system_items msi2 -- component
5407: WHERE ((msi2.bom_item_type = planning
5408: AND msi1.bom_item_type <> planning
5409: )

Line 5406: mtl_system_items msi2 -- component

5402: WHERE bic.bill_sequence_id = to_sequence_id
5403: AND EXISTS (
5404: SELECT NULL
5405: FROM mtl_system_items msi1, -- bom
5406: mtl_system_items msi2 -- component
5407: WHERE ((msi2.bom_item_type = planning
5408: AND msi1.bom_item_type <> planning
5409: )
5410: OR (msi2.bom_item_type IN (model, option_class)

Line 5442: FROM mtl_system_items msi1, -- assembly

5438: SET bic.wip_supply_type = phantom
5439: WHERE bic.bill_sequence_id = to_sequence_id
5440: AND EXISTS (
5441: SELECT NULL
5442: FROM mtl_system_items msi1, -- assembly
5443: mtl_system_items msi2 -- component
5444: WHERE msi2.bom_item_type IN (model, option_class)
5445: AND msi2.inventory_item_id = bic.component_item_id
5446: AND msi2.organization_id = to_org_id

Line 5443: mtl_system_items msi2 -- component

5439: WHERE bic.bill_sequence_id = to_sequence_id
5440: AND EXISTS (
5441: SELECT NULL
5442: FROM mtl_system_items msi1, -- assembly
5443: mtl_system_items msi2 -- component
5444: WHERE msi2.bom_item_type IN (model, option_class)
5445: AND msi2.inventory_item_id = bic.component_item_id
5446: AND msi2.organization_id = to_org_id
5447: AND msi1.inventory_item_id = to_item_id

Line 5459: FROM mtl_system_items msi1, -- assembly

5455: SET bic.optional = 1
5456: WHERE bic.bill_sequence_id = to_sequence_id
5457: AND EXISTS (
5458: SELECT NULL
5459: FROM mtl_system_items msi1, -- assembly
5460: mtl_system_items msi2 -- component
5461: WHERE msi2.base_item_id IS NULL
5462: AND msi2.replenish_to_order_flag = 'Y'
5463: AND msi2.bom_item_type = STANDARD

Line 5460: mtl_system_items msi2 -- component

5456: WHERE bic.bill_sequence_id = to_sequence_id
5457: AND EXISTS (
5458: SELECT NULL
5459: FROM mtl_system_items msi1, -- assembly
5460: mtl_system_items msi2 -- component
5461: WHERE msi2.base_item_id IS NULL
5462: AND msi2.replenish_to_order_flag = 'Y'
5463: AND msi2.bom_item_type = STANDARD
5464: AND msi1.pick_components_flag = 'Y'

Line 5710: mtl_system_items msi,

5706: bsc.attribute15,
5707: bsc.enforce_int_requirements
5708: FROM bom_substitute_components bsc,
5709: bom_components_b bic,
5710: mtl_system_items msi,
5711: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5712: bom_copy_explosions_v bev
5713: WHERE bic.bill_sequence_id = to_sequence_id
5714: AND NVL (bic.eco_for_production, 2) = 2

Line 5711: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

5707: bsc.enforce_int_requirements
5708: FROM bom_substitute_components bsc,
5709: bom_components_b bic,
5710: mtl_system_items msi,
5711: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
5712: bom_copy_explosions_v bev
5713: WHERE bic.bill_sequence_id = to_sequence_id
5714: AND NVL (bic.eco_for_production, 2) = 2
5715: AND bsc.component_sequence_id = bic.created_by

Line 5734: mtl_system_items_b msibs -- to assembly item

5730: SELECT 1
5731: FROM fnd_lookup_values_vl flv,
5732: ego_criteria_templates_v ectv,
5733: ego_criteria_v ecv,
5734: mtl_system_items_b msibs -- to assembly item
5735: WHERE ecv.customization_application_id = 702
5736: AND ecv.region_application_id = 702
5737: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
5738: AND ecv.customization_code = ectv.customization_code

Line 5759: mtl_system_items_b msibs -- to assembly item

5755: (
5756: SELECT 1
5757: FROM fnd_lookup_values_vl flv,
5758: ego_criteria_templates_v ectv,
5759: mtl_system_items_b msibs -- to assembly item
5760: WHERE flv.lookup_type = 'ITEM_TYPE'
5761: AND flv.enabled_flag = 'Y'
5762: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
5763: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 5853: mtl_system_items msi,

5849: bsc.attribute15,
5850: bsc.enforce_int_requirements
5851: FROM bom_substitute_components bsc,
5852: bom_inventory_components bic,
5853: mtl_system_items msi,
5854: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5855: WHERE bic.bill_sequence_id = to_sequence_id
5856: AND NVL (bic.eco_for_production, 2) = 2
5857: AND bsc.component_sequence_id = bic.created_by

Line 5854: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185

5850: bsc.enforce_int_requirements
5851: FROM bom_substitute_components bsc,
5852: bom_inventory_components bic,
5853: mtl_system_items msi,
5854: MTL_SYSTEM_ITEMS AA -- Added corresponding to Bug 6510185
5855: WHERE bic.bill_sequence_id = to_sequence_id
5856: AND NVL (bic.eco_for_production, 2) = 2
5857: AND bsc.component_sequence_id = bic.created_by
5858: AND NVL (bsc.acd_type, 1) <> 3

Line 6317: FROM mtl_system_items_b_kfv msbk

6313: FOR component_rec IN c_component_cur (p_sort_order, p_explode_grp_id)
6314: LOOP
6315: SELECT concatenated_segments
6316: INTO l_component_name
6317: FROM mtl_system_items_b_kfv msbk
6318: WHERE msbk.inventory_item_id = component_rec.component_item_id
6319: AND msbk.organization_id = p_org_id;
6320:
6321: IF (l_component_path IS NULL)

Line 6397: TYPE item_table IS TABLE OF mtl_system_items_interface%ROWTYPE;

6393: p_to_item_id IN NUMBER,
6394: p_master_org_id IN NUMBER
6395: )
6396: IS
6397: TYPE item_table IS TABLE OF mtl_system_items_interface%ROWTYPE;
6398:
6399: l_item_tbl item_table;
6400: l_set_process_id NUMBER := 0;
6401: x_item_table ego_item_pub.item_tbl_type;

Line 6402: x_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

6398:
6399: l_item_tbl item_table;
6400: l_set_process_id NUMBER := 0;
6401: x_item_table ego_item_pub.item_tbl_type;
6402: x_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
6403: x_organization_id mtl_system_items_b.organization_id%TYPE;
6404: x_return_status VARCHAR2 (1);
6405: x_msg_count NUMBER (10);
6406: x_msg_data VARCHAR2 (2000);

Line 6403: x_organization_id mtl_system_items_b.organization_id%TYPE;

6399: l_item_tbl item_table;
6400: l_set_process_id NUMBER := 0;
6401: x_item_table ego_item_pub.item_tbl_type;
6402: x_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
6403: x_organization_id mtl_system_items_b.organization_id%TYPE;
6404: x_return_status VARCHAR2 (1);
6405: x_msg_count NUMBER (10);
6406: x_msg_data VARCHAR2 (2000);
6407: x_message_list error_handler.error_tbl_type;

Line 6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;

6414: l_item_rec_out inv_item_grp.item_rec_type;
6415: l_error_tbl inv_item_grp.error_tbl_type;
6416: x_msg_list error_handler.error_tbl_type;
6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;

Line 6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;

6415: l_error_tbl inv_item_grp.error_tbl_type;
6416: x_msg_list error_handler.error_tbl_type;
6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

Line 6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;

6416: x_msg_list error_handler.error_tbl_type;
6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

Line 6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;

6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

Line 6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;

6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;

Line 6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;

Line 6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;
6428: l_item_count NUMBER := 1;

Line 6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;
6428: l_item_count NUMBER := 1;
6429: l_index NUMBER := 0;

Line 6448: FROM mtl_system_items_b_kfv msibk,

6444: msibk.dual_uom_deviation_low,
6445: msibk.secondary_default_ind,
6446: msibk.tracking_quantity_ind,
6447: msibk.ont_pricing_qty_source
6448: FROM mtl_system_items_b_kfv msibk,
6449: bom_copy_explosions_v bev
6450: WHERE msibk.inventory_item_id = bev.component_item_id
6451: AND msibk.organization_id = bev.organization_id
6452: AND (bev.implementation_date IS NOT NULL

Line 6474: FROM mtl_system_items_b msib

6470: )
6471: */
6472: AND NOT EXISTS (
6473: SELECT 1
6474: FROM mtl_system_items_b msib
6475: WHERE msib.inventory_item_id = bev.component_item_id
6476: AND msib.organization_id = c_org_id)
6477: AND ( NOT EXISTS (
6478: -- Direct Component Action is exclude

Line 6509: FROM mtl_system_items_b_kfv mmsib

6505: IS
6506: SELECT mmsib.primary_uom_code, 1 l_not_exists, concatenated_segments,
6507: mmsib.secondary_uom_code, mmsib.dual_uom_deviation_high, mmsib.dual_uom_deviation_low,
6508: mmsib.secondary_default_ind, mmsib.tracking_quantity_ind, mmsib.ont_pricing_qty_source
6509: FROM mtl_system_items_b_kfv mmsib
6510: WHERE mmsib.inventory_item_id = p_item_id
6511: AND mmsib.organization_id = p_master_org_id
6512: AND NOT EXISTS
6513: ( SELECT 1

Line 6514: FROM mtl_system_items_b msib

6510: WHERE mmsib.inventory_item_id = p_item_id
6511: AND mmsib.organization_id = p_master_org_id
6512: AND NOT EXISTS
6513: ( SELECT 1
6514: FROM mtl_system_items_b msib
6515: WHERE msib.inventory_item_id = mmsib.inventory_item_id
6516: AND msib.organization_id = p_org_id
6517: );
6518: BEGIN

Line 6810: FROM mtl_system_items_b msib

6806: CASE
6807: WHEN EXISTS
6808: (
6809: SELECT 1
6810: FROM mtl_system_items_b msib
6811: WHERE msib.inventory_item_id = p_item_id
6812: AND msib.organization_id = x_org_list_tbl(l_index)
6813: ) THEN
6814: 'Y'

Line 6852: FROM mtl_system_items_b msib,

6848:
6849: CURSOR c1 (cp_item_id IN NUMBER, cp_copy_request_id IN NUMBER)
6850: IS
6851: SELECT mp.organization_code
6852: FROM mtl_system_items_b msib,
6853: mtl_parameters mp,
6854: bom_copy_organization_list bcol
6855: WHERE msib.inventory_item_id = cp_item_id
6856: AND msib.organization_id = mp.organization_id

Line 6979: FROM mtl_system_items_b msib

6975: WHERE bcol.copy_request_id = cp_copy_request_id
6976: AND bcol.organization_id = mp.organization_id
6977: AND NOT EXISTS (
6978: SELECT 1
6979: FROM mtl_system_items_b msib
6980: WHERE msib.inventory_item_id = cp_item_id
6981: AND msib.organization_id = bcol.organization_id);
6982:
6983: l_count NUMBER := 0;

Line 7238: FROM mtl_system_items cmsi,

7234: AND bom.common_bill_sequence_id = to_sequence_id
7235: AND bic.bill_sequence_id = to_sequence_id
7236: AND NOT EXISTS (
7237: SELECT NULL
7238: FROM mtl_system_items cmsi,
7239: mtl_system_items bmsi
7240: WHERE cmsi.organization_id = bom.organization_id
7241: AND cmsi.inventory_item_id =
7242: bic.component_item_id

Line 7239: mtl_system_items bmsi

7235: AND bic.bill_sequence_id = to_sequence_id
7236: AND NOT EXISTS (
7237: SELECT NULL
7238: FROM mtl_system_items cmsi,
7239: mtl_system_items bmsi
7240: WHERE cmsi.organization_id = bom.organization_id
7241: AND cmsi.inventory_item_id =
7242: bic.component_item_id
7243: AND bmsi.organization_id = bom.organization_id

Line 7330: FROM mtl_system_items_b_kfv

7326: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
7327: IS
7328: SELECT concatenated_segments,
7329: primary_uom_code
7330: FROM mtl_system_items_b_kfv
7331: WHERE inventory_item_id = p_item_id
7332: AND organization_id = p_org_id;
7333:
7334: CURSOR l_from_to_comps_csr (

Line 7442: FROM mtl_system_items

7438: rto_flag,
7439: base_item_flag,
7440: itm_type,
7441: itm_cat_grp_id
7442: FROM mtl_system_items
7443: WHERE organization_id = to_org_id
7444: AND inventory_item_id = to_item_id;
7445:
7446: sql_stmt_num := 18;

Line 7875: mtl_system_items msi,

7871: ELSE
7872: to_number(NULL)
7873: END AS to_minor_revision_id
7874: FROM bom_components_b bic,
7875: mtl_system_items msi,
7876: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
7877: bom_copy_explosions_v bev
7878: WHERE bic.bill_sequence_id = x_from_sequence_id
7879: AND bic.component_item_id = msi.inventory_item_id

Line 7876: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

7872: to_number(NULL)
7873: END AS to_minor_revision_id
7874: FROM bom_components_b bic,
7875: mtl_system_items msi,
7876: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
7877: bom_copy_explosions_v bev
7878: WHERE bic.bill_sequence_id = x_from_sequence_id
7879: AND bic.component_item_id = msi.inventory_item_id
7880: AND bic.component_item_id <> to_item_id

Line 7945: mtl_system_items_b msibs -- to assembly item

7941: SELECT 1
7942: FROM fnd_lookup_values_vl flv,
7943: ego_criteria_templates_v ectv,
7944: ego_criteria_v ecv,
7945: mtl_system_items_b msibs -- to assembly item
7946: WHERE ecv.customization_application_id = 702
7947: AND ecv.region_application_id = 702
7948: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
7949: AND ecv.customization_code = ectv.customization_code

Line 7970: mtl_system_items_b msibs -- to assembly item

7966: (
7967: SELECT 1
7968: FROM fnd_lookup_values_vl flv,
7969: ego_criteria_templates_v ectv,
7970: mtl_system_items_b msibs -- to assembly item
7971: WHERE flv.lookup_type = 'ITEM_TYPE'
7972: AND flv.enabled_flag = 'Y'
7973: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
7974: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 8244: mtl_system_items msi,

8240: ELSE
8241: to_number(NULL)
8242: END AS to_minor_revision_id
8243: FROM bom_components_b bic,
8244: mtl_system_items msi,
8245: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8246: bom_copy_explosions_v bev
8247: WHERE bic.bill_sequence_id = x_from_sequence_id
8248: AND bic.component_item_id = msi.inventory_item_id

Line 8245: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

8241: to_number(NULL)
8242: END AS to_minor_revision_id
8243: FROM bom_components_b bic,
8244: mtl_system_items msi,
8245: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8246: bom_copy_explosions_v bev
8247: WHERE bic.bill_sequence_id = x_from_sequence_id
8248: AND bic.component_item_id = msi.inventory_item_id
8249: AND bic.component_item_id <> to_item_id

Line 8313: mtl_system_items_b msibs -- to assembly item

8309: SELECT 1
8310: FROM fnd_lookup_values_vl flv,
8311: ego_criteria_templates_v ectv,
8312: ego_criteria_v ecv,
8313: mtl_system_items_b msibs -- to assembly item
8314: WHERE ecv.customization_application_id = 702
8315: AND ecv.region_application_id = 702
8316: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
8317: AND ecv.customization_code = ectv.customization_code

Line 8338: mtl_system_items_b msibs -- to assembly item

8334: (
8335: SELECT 1
8336: FROM fnd_lookup_values_vl flv,
8337: ego_criteria_templates_v ectv,
8338: mtl_system_items_b msibs -- to assembly item
8339: WHERE flv.lookup_type = 'ITEM_TYPE'
8340: AND flv.enabled_flag = 'Y'
8341: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8342: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 8645: mtl_system_items msi,

8641: ELSE
8642: to_number(NULL)
8643: END AS to_minor_revision_id
8644: FROM bom_components_b bic,
8645: mtl_system_items msi,
8646: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8647: bom_copy_explosions_v bev
8648: WHERE bic.bill_sequence_id = x_from_sequence_id
8649: AND bic.component_item_id = msi.inventory_item_id

Line 8646: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

8642: to_number(NULL)
8643: END AS to_minor_revision_id
8644: FROM bom_components_b bic,
8645: mtl_system_items msi,
8646: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
8647: bom_copy_explosions_v bev
8648: WHERE bic.bill_sequence_id = x_from_sequence_id
8649: AND bic.component_item_id = msi.inventory_item_id
8650: AND bic.component_item_id <> to_item_id

Line 8724: mtl_system_items_b msibs -- to assembly item

8720: SELECT 1
8721: FROM fnd_lookup_values_vl flv,
8722: ego_criteria_templates_v ectv,
8723: ego_criteria_v ecv,
8724: mtl_system_items_b msibs -- to assembly item
8725: WHERE ecv.customization_application_id = 702
8726: AND ecv.region_application_id = 702
8727: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
8728: AND ecv.customization_code = ectv.customization_code

Line 8749: mtl_system_items_b msibs -- to assembly item

8745: (
8746: SELECT 1
8747: FROM fnd_lookup_values_vl flv,
8748: ego_criteria_templates_v ectv,
8749: mtl_system_items_b msibs -- to assembly item
8750: WHERE flv.lookup_type = 'ITEM_TYPE'
8751: AND flv.enabled_flag = 'Y'
8752: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
8753: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 9043: mtl_system_items msi,

9039: ELSE
9040: to_number(NULL)
9041: END AS to_minor_revision_id
9042: FROM bom_components_b bic,
9043: mtl_system_items msi,
9044: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9045: bom_copy_explosions_v bev
9046: WHERE bic.bill_sequence_id = x_from_sequence_id
9047: AND bic.component_item_id = msi.inventory_item_id

Line 9044: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

9040: to_number(NULL)
9041: END AS to_minor_revision_id
9042: FROM bom_components_b bic,
9043: mtl_system_items msi,
9044: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9045: bom_copy_explosions_v bev
9046: WHERE bic.bill_sequence_id = x_from_sequence_id
9047: AND bic.component_item_id = msi.inventory_item_id
9048: AND bic.component_item_id <> to_item_id

Line 9124: mtl_system_items_b msibs -- to assembly item

9120: SELECT 1
9121: FROM fnd_lookup_values_vl flv,
9122: ego_criteria_templates_v ectv,
9123: ego_criteria_v ecv,
9124: mtl_system_items_b msibs -- to assembly item
9125: WHERE ecv.customization_application_id = 702
9126: AND ecv.region_application_id = 702
9127: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
9128: AND ecv.customization_code = ectv.customization_code

Line 9149: mtl_system_items_b msibs -- to assembly item

9145: (
9146: SELECT 1
9147: FROM fnd_lookup_values_vl flv,
9148: ego_criteria_templates_v ectv,
9149: mtl_system_items_b msibs -- to assembly item
9150: WHERE flv.lookup_type = 'ITEM_TYPE'
9151: AND flv.enabled_flag = 'Y'
9152: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9153: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 9442: mtl_system_items msi,

9438: ELSE
9439: to_number(NULL)
9440: END AS to_minor_revision_id
9441: FROM bom_components_b bic,
9442: mtl_system_items msi,
9443: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9444: bom_copy_explosions_v bev
9445: WHERE bic.bill_sequence_id = x_from_sequence_id
9446: AND bic.component_item_id = msi.inventory_item_id

Line 9443: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

9439: to_number(NULL)
9440: END AS to_minor_revision_id
9441: FROM bom_components_b bic,
9442: mtl_system_items msi,
9443: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
9444: bom_copy_explosions_v bev
9445: WHERE bic.bill_sequence_id = x_from_sequence_id
9446: AND bic.component_item_id = msi.inventory_item_id
9447: AND bic.component_item_id <> to_item_id

Line 9511: mtl_system_items_b msibs -- to assembly item

9507: SELECT 1
9508: FROM fnd_lookup_values_vl flv,
9509: ego_criteria_templates_v ectv,
9510: ego_criteria_v ecv,
9511: mtl_system_items_b msibs -- to assembly item
9512: WHERE ecv.customization_application_id = 702
9513: AND ecv.region_application_id = 702
9514: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
9515: AND ecv.customization_code = ectv.customization_code

Line 9536: mtl_system_items_b msibs -- to assembly item

9532: (
9533: SELECT 1
9534: FROM fnd_lookup_values_vl flv,
9535: ego_criteria_templates_v ectv,
9536: mtl_system_items_b msibs -- to assembly item
9537: WHERE flv.lookup_type = 'ITEM_TYPE'
9538: AND flv.enabled_flag = 'Y'
9539: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
9540: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)

Line 9637: mtl_system_items_b_kfv msbk1,

9633:
9634: SELECT COUNT (*)
9635: INTO l_no_access_comp_cnt
9636: FROM bom_components_b bcb,
9637: mtl_system_items_b_kfv msbk1,
9638: bom_copy_explosions_v bev
9639: WHERE bcb.bill_sequence_id = x_from_sequence_id
9640: AND bcb.component_item_id = msbk1.inventory_item_id
9641: AND bcb.component_item_id <> to_item_id

Line 9738: mtl_system_items_b_kfv msbk1,

9734: NULL,
9735: fnd_global.conc_program_id,
9736: sysdate
9737: FROM bom_components_b bcb,
9738: mtl_system_items_b_kfv msbk1,
9739: bom_copy_explosions_v bev
9740: WHERE msbk1.inventory_item_id = from_item_id
9741: AND msbk1.organization_id = from_org_id
9742: AND bcb.component_sequence_id = bev.component_sequence_id

Line 9766: mtl_system_items_b_kfv msbk1,

9762: THEN
9763: SELECT COUNT (*)
9764: INTO l_no_access_comp_cnt
9765: FROM bom_components_b bcb,
9766: mtl_system_items_b_kfv msbk1,
9767: bom_copy_explosions_v bev
9768: WHERE bcb.bill_sequence_id = x_from_sequence_id
9769: AND bcb.component_item_id = msbk1.inventory_item_id
9770: AND bcb.component_item_id <> to_item_id

Line 9867: mtl_system_items_b_kfv msbk1,

9863: NULL,
9864: fnd_global.conc_program_id,
9865: sysdate
9866: FROM bom_components_b bcb,
9867: mtl_system_items_b_kfv msbk1,
9868: bom_copy_explosions_v bev
9869: WHERE msbk1.inventory_item_id = from_item_id
9870: AND msbk1.organization_id = from_org_id
9871: AND bcb.component_sequence_id = bev.component_sequence_id

Line 9932: mtl_system_items_b msib1, -- component

9928: NULL,
9929: fnd_global.conc_program_id,
9930: sysdate
9931: FROM bom_components_b bcb,
9932: mtl_system_items_b msib1, -- component
9933: bom_copy_explosions_v bev
9934: WHERE bcb.bill_sequence_id = x_from_sequence_id
9935: AND bcb.component_item_id = msib1.inventory_item_id
9936: AND bcb.component_item_id <> to_item_id

Line 10133: mtl_system_items_b msib1,

10129: NULL,
10130: fnd_global.conc_program_id,
10131: sysdate
10132: FROM bom_components_b bcb,
10133: mtl_system_items_b msib1,
10134: bom_copy_explosions_v bev
10135: WHERE bcb.bill_sequence_id = x_from_sequence_id
10136: AND bcb.component_item_id = msib1.inventory_item_id
10137: AND bcb.component_item_id <> to_item_id

Line 10336: mtl_system_items_b msib

10332: NULL,
10333: fnd_global.conc_program_id,
10334: sysdate
10335: FROM bom_components_b bcb,
10336: mtl_system_items_b msib
10337: WHERE bcb.bill_sequence_id = to_sequence_id
10338: AND bcb.component_item_id = msib.inventory_item_id
10339: AND msib.organization_id = to_org_id
10340: AND 'Y' <>

Line 10401: mtl_system_items_b msib

10397: NULL,
10398: fnd_global.conc_program_id,
10399: sysdate
10400: FROM bom_components_b bcb,
10401: mtl_system_items_b msib
10402: WHERE bcb.bill_sequence_id = to_sequence_id
10403: AND bcb.component_item_id = msib.inventory_item_id
10404: AND msib.organization_id = to_org_id
10405: AND 'Y' <>

Line 10807: mtl_system_items_b msib1,

10803: NULL,
10804: fnd_global.conc_program_id,
10805: sysdate
10806: FROM bom_components_b bcb,
10807: mtl_system_items_b msib1,
10808: mtl_system_items_b msib2
10809: WHERE bcb.bill_sequence_id = to_sequence_id
10810: AND (msib1.bom_item_type = planning
10811: AND msib2.bom_item_type <> planning

Line 10808: mtl_system_items_b msib2

10804: fnd_global.conc_program_id,
10805: sysdate
10806: FROM bom_components_b bcb,
10807: mtl_system_items_b msib1,
10808: mtl_system_items_b msib2
10809: WHERE bcb.bill_sequence_id = to_sequence_id
10810: AND (msib1.bom_item_type = planning
10811: AND msib2.bom_item_type <> planning
10812: )

Line 10861: mtl_system_items_b msib1,

10857: NULL,
10858: fnd_global.conc_program_id,
10859: sysdate
10860: FROM bom_components_b bcb,
10861: mtl_system_items_b msib1,
10862: mtl_system_items_b msib2
10863: WHERE bcb.bill_sequence_id = to_sequence_id
10864: AND (msib1.bom_item_type IN (model, option_class)
10865: AND msib2.bom_item_type = STANDARD

Line 10862: mtl_system_items_b msib2

10858: fnd_global.conc_program_id,
10859: sysdate
10860: FROM bom_components_b bcb,
10861: mtl_system_items_b msib1,
10862: mtl_system_items_b msib2
10863: WHERE bcb.bill_sequence_id = to_sequence_id
10864: AND (msib1.bom_item_type IN (model, option_class)
10865: AND msib2.bom_item_type = STANDARD
10866: AND msib2.base_item_id IS NULL

Line 10916: mtl_system_items_b msib1, -- Comp

10912: NULL,
10913: fnd_global.conc_program_id,
10914: sysdate
10915: FROM bom_components_b bcb,
10916: mtl_system_items_b msib1, -- Comp
10917: mtl_system_items_b msib2 -- Structure
10918: WHERE bcb.bill_sequence_id = to_sequence_id
10919: AND (msib1.replenish_to_order_flag = 'Y'
10920: AND msib1.bom_item_type = option_class

Line 10917: mtl_system_items_b msib2 -- Structure

10913: fnd_global.conc_program_id,
10914: sysdate
10915: FROM bom_components_b bcb,
10916: mtl_system_items_b msib1, -- Comp
10917: mtl_system_items_b msib2 -- Structure
10918: WHERE bcb.bill_sequence_id = to_sequence_id
10919: AND (msib1.replenish_to_order_flag = 'Y'
10920: AND msib1.bom_item_type = option_class
10921: AND msib2.pick_components_flag = 'Y'

Line 10971: mtl_system_items_b msib1, -- Comp

10967: NULL,
10968: fnd_global.conc_program_id,
10969: sysdate
10970: FROM bom_components_b bcb,
10971: mtl_system_items_b msib1, -- Comp
10972: mtl_system_items_b msib2 -- Structure
10973: WHERE bcb.bill_sequence_id = to_sequence_id
10974: AND (msib1.replenish_to_order_flag = 'Y'
10975: AND msib1.bom_item_type = STANDARD

Line 10972: mtl_system_items_b msib2 -- Structure

10968: fnd_global.conc_program_id,
10969: sysdate
10970: FROM bom_components_b bcb,
10971: mtl_system_items_b msib1, -- Comp
10972: mtl_system_items_b msib2 -- Structure
10973: WHERE bcb.bill_sequence_id = to_sequence_id
10974: AND (msib1.replenish_to_order_flag = 'Y'
10975: AND msib1.bom_item_type = STANDARD
10976: AND msib2.pick_components_flag = 'Y'

Line 11027: mtl_system_items_b msib1, -- Comp

11023: NULL,
11024: fnd_global.conc_program_id,
11025: sysdate
11026: FROM bom_components_b bcb,
11027: mtl_system_items_b msib1, -- Comp
11028: mtl_system_items_b msib2 -- Structure
11029: WHERE bcb.bill_sequence_id = to_sequence_id
11030: AND (msib1.pick_components_flag = 'Y'
11031: AND msib2.replenish_to_order_flag = 'Y'

Line 11028: mtl_system_items_b msib2 -- Structure

11024: fnd_global.conc_program_id,
11025: sysdate
11026: FROM bom_components_b bcb,
11027: mtl_system_items_b msib1, -- Comp
11028: mtl_system_items_b msib2 -- Structure
11029: WHERE bcb.bill_sequence_id = to_sequence_id
11030: AND (msib1.pick_components_flag = 'Y'
11031: AND msib2.replenish_to_order_flag = 'Y'
11032: )

Line 11045: FROM mtl_system_items msi1, -- bom

11041: DELETE FROM bom_inventory_components bic
11042: WHERE bic.bill_sequence_id = to_sequence_id
11043: AND EXISTS (
11044: SELECT NULL
11045: FROM mtl_system_items msi1, -- bom
11046: mtl_system_items msi2 -- component
11047: WHERE ((msi2.bom_item_type = planning
11048: AND msi1.bom_item_type <> planning
11049: )

Line 11046: mtl_system_items msi2 -- component

11042: WHERE bic.bill_sequence_id = to_sequence_id
11043: AND EXISTS (
11044: SELECT NULL
11045: FROM mtl_system_items msi1, -- bom
11046: mtl_system_items msi2 -- component
11047: WHERE ((msi2.bom_item_type = planning
11048: AND msi1.bom_item_type <> planning
11049: )
11050: OR (msi2.bom_item_type IN (model, option_class)

Line 11083: FROM mtl_system_items msi1, -- assembly

11079: SET bic.wip_supply_type = phantom
11080: WHERE bic.bill_sequence_id = to_sequence_id
11081: AND EXISTS (
11082: SELECT NULL
11083: FROM mtl_system_items msi1, -- assembly
11084: mtl_system_items msi2 -- component
11085: WHERE msi2.bom_item_type IN (model, option_class)
11086: AND msi2.inventory_item_id = bic.component_item_id
11087: AND msi2.organization_id = to_org_id

Line 11084: mtl_system_items msi2 -- component

11080: WHERE bic.bill_sequence_id = to_sequence_id
11081: AND EXISTS (
11082: SELECT NULL
11083: FROM mtl_system_items msi1, -- assembly
11084: mtl_system_items msi2 -- component
11085: WHERE msi2.bom_item_type IN (model, option_class)
11086: AND msi2.inventory_item_id = bic.component_item_id
11087: AND msi2.organization_id = to_org_id
11088: AND msi1.inventory_item_id = to_item_id

Line 11101: FROM mtl_system_items msi1, -- assembly

11097: SET bic.optional = 1
11098: WHERE bic.bill_sequence_id = to_sequence_id
11099: AND EXISTS (
11100: SELECT NULL
11101: FROM mtl_system_items msi1, -- assembly
11102: mtl_system_items msi2 -- component
11103: WHERE msi2.base_item_id IS NULL
11104: AND msi2.replenish_to_order_flag = 'Y'
11105: AND msi2.bom_item_type = STANDARD

Line 11102: mtl_system_items msi2 -- component

11098: WHERE bic.bill_sequence_id = to_sequence_id
11099: AND EXISTS (
11100: SELECT NULL
11101: FROM mtl_system_items msi1, -- assembly
11102: mtl_system_items msi2 -- component
11103: WHERE msi2.base_item_id IS NULL
11104: AND msi2.replenish_to_order_flag = 'Y'
11105: AND msi2.bom_item_type = STANDARD
11106: AND msi1.pick_components_flag = 'Y'

Line 11272: mtl_system_items msi,

11268: bsc.attribute15,
11269: bsc.enforce_int_requirements
11270: FROM bom_substitute_components bsc,
11271: bom_components_b bic,
11272: mtl_system_items msi,
11273: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11274: bom_copy_explosions_v bev
11275: WHERE bic.bill_sequence_id = to_sequence_id
11276: AND NVL (bic.eco_for_production, 2) = 2

Line 11273: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185

11269: bsc.enforce_int_requirements
11270: FROM bom_substitute_components bsc,
11271: bom_components_b bic,
11272: mtl_system_items msi,
11273: MTL_SYSTEM_ITEMS AA , -- Added corresponding to Bug 6510185
11274: bom_copy_explosions_v bev
11275: WHERE bic.bill_sequence_id = to_sequence_id
11276: AND NVL (bic.eco_for_production, 2) = 2
11277: AND bsc.component_sequence_id = bic.created_by

Line 11297: mtl_system_items_b msibs -- to assembly item

11293: SELECT 1
11294: FROM fnd_lookup_values_vl flv,
11295: ego_criteria_templates_v ectv,
11296: ego_criteria_v ecv,
11297: mtl_system_items_b msibs -- to assembly item
11298: WHERE ecv.customization_application_id = 702
11299: AND ecv.region_application_id = 702
11300: AND ecv.region_code = 'BOM_ITEM_TYPE_REGION'
11301: AND ecv.customization_code = ectv.customization_code

Line 11322: mtl_system_items_b msibs -- to assembly item

11318: (
11319: SELECT 1
11320: FROM fnd_lookup_values_vl flv,
11321: ego_criteria_templates_v ectv,
11322: mtl_system_items_b msibs -- to assembly item
11323: WHERE flv.lookup_type = 'ITEM_TYPE'
11324: AND flv.enabled_flag = 'Y'
11325: AND (flv.start_date_active IS NULL OR flv.start_date_active < sysdate)
11326: AND (flv.end_date_active IS NULL OR flv.end_date_active > sysdate)