APPS.MSD_DEM_SR_UTIL dependencies on STANDARD

Line 16: C_STANDARD constant number := 4;

12: /* BOM ITEM TYPE */
13: C_MODEL constant number := 1;
14: C_OPTION_CLASS constant number := 2;
15: C_PLANNING constant number := 3;
16: C_STANDARD constant number := 4;
17: C_PRODUCT_FAMILY constant number := 5;
18:
19:
20: /*** PUBLIC PROCEDURES ***

Line 145: WHERE product_group_type = 'Standard';

141:
142: SELECT multi_org_flag
143: INTO x_multi_org_flag
144: FROM fnd_product_groups
145: WHERE product_group_type = 'Standard';
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: x_multi_org_flag := 'Y';

Line 249: ** standard conversion, which is defined for all items, is used.

245: **
246: ** 1. The conversion always starts from the conversion defined, if exists,
247: ** for an specified item.
248: ** 2. If the conversion id not defined for that specific item, then the
249: ** standard conversion, which is defined for all items, is used.
250: */
251:
252: /*
253: open base_uom_code_conversion(item_id, uom_code);

Line 301: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)

297: bic.bill_sequence_id = bbm.bill_sequence_id
298: and bbm.organization_id = morg.organization_id
299: and msi.organization_id = bbm.organization_id
300: and msi.inventory_item_id = bbm.assembly_item_id
301: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
302: and bic.optional = C_YES
303: and ( msi.bom_item_type = 2 or
304: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
305: )

Line 760: AND msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)

756: AND bic.bill_sequence_id = bbm.bill_sequence_id
757: AND bbm.organization_id = mdaio.organization_id
758: AND msi.organization_id = bbm.organization_id
759: AND msi.inventory_item_id = bbm.assembly_item_id
760: AND msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
761: AND bic.optional = C_YES;
762:
763: CURSOR C_PARENT_ITEM
764: IS