APPS.MSD_DEM_SR_UTIL dependencies on STANDARD

Line 15: C_STANDARD constant number := 4;

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

Line 126: WHERE product_group_type = 'Standard';

122:
123: SELECT multi_org_flag
124: INTO x_multi_org_flag
125: FROM fnd_product_groups
126: WHERE product_group_type = 'Standard';
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: x_multi_org_flag := 'Y';

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

221: **
222: ** 1. The conversion always starts from the conversion defined, if exists,
223: ** for an specified item.
224: ** 2. If the conversion id not defined for that specific item, then the
225: ** standard conversion, which is defined for all items, is used.
226: */
227:
228: /*
229: open base_uom_code_conversion(item_id, uom_code);

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

273: bic.bill_sequence_id = bbm.bill_sequence_id
274: and bbm.organization_id = morg.organization_id
275: and msi.organization_id = bbm.organization_id
276: and msi.inventory_item_id = bbm.assembly_item_id
277: and msi.bom_item_type not in (C_PLANNING, C_STANDARD, C_PRODUCT_FAMILY)
278: and bic.optional = C_YES
279: and ( msi.bom_item_type = 2 or
280: ( msi.bom_item_type = 1 and msi.ato_forecast_control in (1, 2) )
281: )