[Home] [Help]
33: /* BOM ITEM TYPE */
34: C_MODEL constant number := 1;
35: C_OPTION_CLASS constant number := 2;
36: C_PLANNING constant number := 3;
37: C_STANDARD constant number := 4;
38: C_PRODUCT_FAMILY constant number := 5;
39:
40:
41:
155: **
156: ** 1. The conversion always starts from the conversion defined, if exists,
157: ** for an specified item.
158: ** 2. If the conversion id not defined for that specific item, then the
159: ** standard conversion, which is defined for all items, is used.
160: */
161:
162: /*
163: open base_uom_code_conversion(item_id, uom_code);
315: begin
316:
317: select fpg.MULTI_ORG_FLAG into x_product_group_type
318: from fnd_product_groups fpg
319: where fpg.product_group_type='Standard' ;
320:
321: exception
322:
323: when others then
534: bic.bill_sequence_id = bbm.bill_sequence_id
535: and bbm.organization_id = morg.organization_id
536: and msi.organization_id = bbm.organization_id
537: and msi.inventory_item_id = bbm.assembly_item_id
538: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
539: and bic.optional = C_YES
540: and ( msi.bom_item_type = 2 or
541: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
542: )
576: bic.bill_sequence_id = bbm.bill_sequence_id
577: and bbm.organization_id = morg.organization_id
578: and msi.organization_id = bbm.organization_id
579: and msi.inventory_item_id = bbm.assembly_item_id
580: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
581: and bic.optional = C_YES
582: and ( msi.bom_item_type = 2 or
583: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
584: )
637: and bic.bill_sequence_id = bbm.bill_sequence_id
638: and bbm.organization_id = morg.organization_id
639: and msi.organization_id = bbm.organization_id
640: and msi.inventory_item_id = bbm.assembly_item_id
641: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
642: and bic.optional = C_YES;
643:
644:
645: