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 STANDARD

Line 590: STANDARD CONSTANT NUMBER := 4;

586: eng_to_bom CONSTANT NUMBER := 4;
587: model CONSTANT NUMBER := 1;
588: option_class CONSTANT NUMBER := 2;
589: planning CONSTANT NUMBER := 3;
590: STANDARD CONSTANT NUMBER := 4;
591: phantom CONSTANT NUMBER := 6;
592: x_from_sequence_id NUMBER := from_sequence_id;
593: x_from_org_id NUMBER := from_org_id;
594: to_rtg_seq_id NUMBER;

Line 4200: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',

4196: get_current_item_rev (bcb.component_item_id,
4197: from_org_id,
4198: rev_date
4199: ),
4200: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
4201: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
4202: bom_globals.get_item_name(to_item_id, from_org_id)
4203: ),
4204: 'BOM_COPY',

Line 5109: -- Configured items are ATO standard items that have a base item id.

5105: -- Ensure the following rule matrix is observed
5106: --
5107: -- Y = Allowed N = Not Allowed
5108: -- P = Must be Phantom O = Must be Optional
5109: -- Configured items are ATO standard items that have a base item id.
5110: -- ATO items have Replenish to Order flags set to "Y".
5111: -- PTO items have Pick Component flags set to "Y".
5112: --
5113: -- Parent

Line 5120: -- ATO Standard | Y Y Y Y O O N

Line 5123: -- PTO Standard | N N N N Y Y Y

5119: -- ATO Opt Class | P P P N N N N
5120: -- ATO Standard | Y Y Y Y O O N
5121: -- PTO Model | N N N N P P N
5122: -- PTO Opt Class | N N N N P P N
5123: -- PTO Standard | N N N N Y Y Y
5124: --
5125: --
5126: -- Log errors for multi level structure copy.
5127: IF specific_copy_flag = 'Y'

Line 5182: -- Standard bill without base model cannot have Option class or Model components.

5178: AND msib2.organization_id = to_org_id
5179: AND msib1.inventory_item_id = bcb.component_item_id
5180: AND msib1.organization_id = to_org_id;
5181:
5182: -- Standard bill without base model cannot have Option class or Model components.
5183: INSERT INTO mtl_interface_errors
5184: (unique_id,
5185: organization_id,
5186: transaction_id,

Line 5228: AND msib2.bom_item_type = STANDARD

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
5230: )
5231: AND msib2.inventory_item_id = to_item_id
5232: AND msib2.organization_id = to_org_id

Line 5290: -- No ATO standard items for PTO standard bills

5286: AND msib2.organization_id = to_org_id
5287: AND msib1.inventory_item_id = bcb.component_item_id
5288: AND msib1.organization_id = to_org_id;
5289:
5290: -- No ATO standard items for PTO standard bills
5291: INSERT INTO mtl_interface_errors
5292: (unique_id,
5293: organization_id,
5294: transaction_id,

Line 5336: AND msib1.bom_item_type = STANDARD

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'
5338: AND msib2.bom_item_type = STANDARD
5339: )
5340: AND msib2.inventory_item_id = to_item_id

Line 5338: AND msib2.bom_item_type = STANDARD

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'
5338: AND msib2.bom_item_type = STANDARD
5339: )
5340: AND msib2.inventory_item_id = to_item_id
5341: AND msib2.organization_id = to_org_id
5342: AND msib1.inventory_item_id = bcb.component_item_id

Line 5411: AND msi1.bom_item_type = STANDARD

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)
5411: AND msi1.bom_item_type = STANDARD
5412: AND msi1.base_item_id IS NULL
5413: )
5414: OR (msi2.replenish_to_order_flag = 'Y'
5415: AND msi2.bom_item_type = option_class

Line 5419: AND msi2.bom_item_type = STANDARD

5415: AND msi2.bom_item_type = option_class
5416: AND msi1.pick_components_flag = 'Y'
5417: )
5418: OR (msi2.replenish_to_order_flag = 'Y'
5419: AND msi2.bom_item_type = STANDARD
5420: AND msi1.pick_components_flag = 'Y'
5421: AND msi1.bom_item_type = STANDARD
5422: )
5423: OR (msi2.pick_components_flag = 'Y'

Line 5421: AND msi1.bom_item_type = STANDARD

5417: )
5418: OR (msi2.replenish_to_order_flag = 'Y'
5419: AND msi2.bom_item_type = STANDARD
5420: AND msi1.pick_components_flag = 'Y'
5421: AND msi1.bom_item_type = STANDARD
5422: )
5423: OR (msi2.pick_components_flag = 'Y'
5424: AND msi1.replenish_to_order_flag = 'Y'
5425: )

Line 5463: AND msi2.bom_item_type = STANDARD

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'
5465: AND msi1.bom_item_type IN (model, option_class)
5466: AND msi2.inventory_item_id = bic.component_item_id
5467: AND msi2.organization_id = to_org_id

Line 7151: STANDARD CONSTANT NUMBER := 4;

7147: eng_to_bom CONSTANT NUMBER := 4;
7148: model CONSTANT NUMBER := 1;
7149: option_class CONSTANT NUMBER := 2;
7150: planning CONSTANT NUMBER := 3;
7151: STANDARD CONSTANT NUMBER := 4;
7152: phantom CONSTANT NUMBER := 6;
7153: x_from_sequence_id NUMBER := from_sequence_id;
7154: x_from_org_id NUMBER := from_org_id;
7155: to_rtg_seq_id NUMBER;

Line 10118: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',

10114: get_current_item_rev (bcb.component_item_id,
10115: from_org_id,
10116: rev_date
10117: ),
10118: GET_MESSAGE ('BOM_COPY_ERR_COMP_NOT_STANDARD',
10119: bom_globals.get_item_name(bcb.component_item_id, from_org_id),
10120: bom_globals.get_item_name(to_item_id, from_org_id)
10121: ),
10122: 'BOM_COPY',

Line 10747: -- Configured items are ATO standard items that have a base item id.

10743: -- Ensure the following rule matrix is observed
10744: --
10745: -- Y = Allowed N = Not Allowed
10746: -- P = Must be Phantom O = Must be Optional
10747: -- Configured items are ATO standard items that have a base item id.
10748: -- ATO items have Replenish to Order flags set to "Y".
10749: -- PTO items have Pick Component flags set to "Y".
10750: --
10751: -- Parent

Line 10758: -- ATO Standard | Y Y Y Y O O N

Line 10761: -- PTO Standard | N N N N Y Y Y

10757: -- ATO Opt Class | P P P N N N N
10758: -- ATO Standard | Y Y Y Y O O N
10759: -- PTO Model | N N N N P P N
10760: -- PTO Opt Class | N N N N P P N
10761: -- PTO Standard | N N N N Y Y Y
10762: --
10763: --
10764: -- Log errors for multi level structure copy.
10765: -- Planning bill should contain only planning components

Line 10819: -- Standard bill without base model cannot have Option class or Model components.

10815: AND msib1.inventory_item_id = bcb.component_item_id
10816: AND msib1.organization_id = to_org_id
10817: AND bcb.revised_item_sequence_id = rev_item_seq_id;
10818:
10819: -- Standard bill without base model cannot have Option class or Model components.
10820: INSERT INTO mtl_interface_errors
10821: (unique_id,
10822: organization_id,
10823: transaction_id,

Line 10865: AND msib2.bom_item_type = STANDARD

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
10867: )
10868: AND msib2.inventory_item_id = to_item_id
10869: AND msib2.organization_id = to_org_id

Line 10929: -- No ATO standard items for PTO standard bills

10925: AND msib1.inventory_item_id = bcb.component_item_id
10926: AND msib1.organization_id = to_org_id
10927: AND bcb.revised_item_sequence_id = rev_item_seq_id;
10928:
10929: -- No ATO standard items for PTO standard bills
10930: INSERT INTO mtl_interface_errors
10931: (unique_id,
10932: organization_id,
10933: transaction_id,

Line 10975: AND msib1.bom_item_type = STANDARD

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'
10977: AND msib2.bom_item_type = STANDARD
10978: )
10979: AND msib2.inventory_item_id = to_item_id

Line 10977: AND msib2.bom_item_type = STANDARD

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'
10977: AND msib2.bom_item_type = STANDARD
10978: )
10979: AND msib2.inventory_item_id = to_item_id
10980: AND msib2.organization_id = to_org_id
10981: AND msib1.inventory_item_id = bcb.component_item_id

Line 11051: AND msi1.bom_item_type = STANDARD

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)
11051: AND msi1.bom_item_type = STANDARD
11052: AND msi1.base_item_id IS NULL
11053: )
11054: OR (msi2.replenish_to_order_flag = 'Y'
11055: AND msi2.bom_item_type = option_class

Line 11059: AND msi2.bom_item_type = STANDARD

11055: AND msi2.bom_item_type = option_class
11056: AND msi1.pick_components_flag = 'Y'
11057: )
11058: OR (msi2.replenish_to_order_flag = 'Y'
11059: AND msi2.bom_item_type = STANDARD
11060: AND msi1.pick_components_flag = 'Y'
11061: AND msi1.bom_item_type = STANDARD
11062: )
11063: OR (msi2.pick_components_flag = 'Y'

Line 11061: AND msi1.bom_item_type = STANDARD

11057: )
11058: OR (msi2.replenish_to_order_flag = 'Y'
11059: AND msi2.bom_item_type = STANDARD
11060: AND msi1.pick_components_flag = 'Y'
11061: AND msi1.bom_item_type = STANDARD
11062: )
11063: OR (msi2.pick_components_flag = 'Y'
11064: AND msi1.replenish_to_order_flag = 'Y'
11065: )

Line 11105: AND msi2.bom_item_type = STANDARD

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'
11107: AND msi1.bom_item_type IN (model, option_class)
11108: AND msi2.inventory_item_id = bic.component_item_id
11109: AND msi2.organization_id = to_org_id