[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);
316: begin
317:
318: select fpg.MULTI_ORG_FLAG into x_product_group_type
319: from fnd_product_groups fpg
320: where fpg.product_group_type='Standard' ;
321:
322: exception
323:
324: when others then
535: bic.bill_sequence_id = bbm.bill_sequence_id
536: and bbm.organization_id = morg.organization_id
537: and msi.organization_id = bbm.organization_id
538: and msi.inventory_item_id = bbm.assembly_item_id
539: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
540: and bic.optional = C_YES
541: and ( msi.bom_item_type = 2 or
542: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
543: )
577: bic.bill_sequence_id = bbm.bill_sequence_id
578: and bbm.organization_id = morg.organization_id
579: and msi.organization_id = bbm.organization_id
580: and msi.inventory_item_id = bbm.assembly_item_id
581: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
582: and bic.optional = C_YES
583: and ( msi.bom_item_type = 2 or
584: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
585: )
638: and bic.bill_sequence_id = bbm.bill_sequence_id
639: and bbm.organization_id = morg.organization_id
640: and msi.organization_id = bbm.organization_id
641: and msi.inventory_item_id = bbm.assembly_item_id
642: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
643: and bic.optional = C_YES;
644:
645:
646: