DBA Data[Home] [Help]

APPS.MSC_CONFIG_FF dependencies on FND_PROFILE_OPTIONS

Line 321: from fnd_profile_options

317: set profile_option_value = to_char(item_attr1)
318: where application_id = 723
319: and level_id = 10001
320: and profile_option_id = (select profile_option_id
321: from fnd_profile_options
322: where application_id = 723
323: and profile_option_name = 'MSO_ITEM_DMD_PENALTY');
324:
325: END IF;

Line 386: from fnd_profile_options

382: set profile_option_value = to_char(item_attr2)
383: where application_id = 723
384: and level_id = 10001
385: and profile_option_id = (select profile_option_id
386: from fnd_profile_options
387: where application_id = 723
388: and profile_option_name = 'MSO_ITEM_CAP_PENALTY');
389:
390: END IF;

Line 456: from fnd_profile_options

452: set profile_option_value = to_char(org_attr1)
453: where application_id = 723
454: and level_id = 10001
455: and profile_option_id = (select profile_option_id
456: from fnd_profile_options
457: where application_id = 723
458: and profile_option_name = 'MSO_ORG_DMD_PENALTY');
459:
460: END IF;

Line 521: from fnd_profile_options

517: set profile_option_value = to_char(org_attr2)
518: where application_id = 723
519: and level_id = 10001
520: and profile_option_id = (select profile_option_id
521: from fnd_profile_options
522: where application_id = 723
523: and profile_option_name = 'MSO_ORG_ITEM_PENALTY');
524:
525: END IF;

Line 587: from fnd_profile_options

583: set profile_option_value = to_char(org_attr3)
584: where application_id = 723
585: and level_id = 10001
586: and profile_option_id = (select profile_option_id
587: from fnd_profile_options
588: where application_id = 723
589: and profile_option_name = 'MSO_ORG_RES_PENALTY');
590:
591: END IF;

Line 653: from fnd_profile_options

649: set profile_option_value = to_char(org_attr4)
650: where application_id = 723
651: and level_id = 10001
652: and profile_option_id = (select profile_option_id
653: from fnd_profile_options
654: where application_id = 723
655: and profile_option_name = 'MSO_ORG_TRSP_PENALTY');
656:
657: END IF;

Line 724: from fnd_profile_options

720: set profile_option_value = to_char(dept_attr1)
721: where application_id = 724
722: and level_id = 10001
723: and profile_option_id = (select profile_option_id
724: from fnd_profile_options
725: where application_id = 724
726: and profile_option_name = 'MSC_AGGREG_RES_NAME');
727:
728: END IF;

Line 797: from fnd_profile_options

793: set profile_option_value = to_char(dept_attr2)
794: where application_id = 723
795: and level_id = 10001
796: and profile_option_id = (select profile_option_id
797: from fnd_profile_options
798: where application_id = 723
799: and profile_option_name = 'MSO_RES_PENALTY');
800:
801: END IF;

Line 867: from fnd_profile_options

863: set profile_option_value = to_char(supp_attr1)
864: where application_id = 723
865: and level_id = 10001
866: and profile_option_id = (select profile_option_id
867: from fnd_profile_options
868: where application_id = 723
869: and profile_option_name = 'MSO_SUP_CAP_PENALTY');
870:
871: END IF;

Line 938: from fnd_profile_options

934: set profile_option_value = to_char(subst_attr1)
935: where application_id = 724
936: and level_id = 10001
937: and profile_option_id = (select profile_option_id
938: from fnd_profile_options
939: where application_id = 724
940: and profile_option_name = 'MSC_BOM_SUBST_PRIORITY');
941:
942: END IF;

Line 1009: from fnd_profile_options

1005: set profile_option_value = to_char(trans_attr1)
1006: where application_id = 723
1007: and level_id = 10001
1008: and profile_option_id = (select profile_option_id
1009: from fnd_profile_options
1010: where application_id = 723
1011: and profile_option_name = 'MSO_TRSP_PENALTY');
1012:
1013: END IF;

Line 1080: from fnd_profile_options

1076: set profile_option_value = to_char(bom_attr1)
1077: where application_id = 724
1078: and level_id = 10001
1079: and profile_option_id = (select profile_option_id
1080: from fnd_profile_options
1081: where application_id = 724
1082: and profile_option_name = 'MSC_ALT_BOM_COST');
1083:
1084: END IF;

Line 1151: from fnd_profile_options

1147: set profile_option_value = to_char(forecast_attr1)
1148: where application_id = 723
1149: and level_id = 10001
1150: and profile_option_id = (select profile_option_id
1151: from fnd_profile_options
1152: where application_id = 723
1153: and profile_option_name = 'MSO_FCST_PENALTY');
1154:
1155: END IF;

Line 1221: from fnd_profile_options

1217: set profile_option_value = to_char(line_attr1)
1218: where application_id = 724
1219: and level_id = 10001
1220: and profile_option_id = (select profile_option_id
1221: from fnd_profile_options
1222: where application_id = 724
1223: and profile_option_name = 'MSC_LINE_RES_GROUP');
1224:
1225: END IF;

Line 1286: from fnd_profile_options

1282: set profile_option_value = to_char(schedule_attr1)
1283: where application_id = 704
1284: and level_id = 10001
1285: and profile_option_id = (select profile_option_id
1286: from fnd_profile_options
1287: where application_id = 704
1288: and profile_option_name = 'MRP_DMD_PRIORITY_FLEX_NUM');
1289:
1290: END IF;

Line 1606: from fnd_profile_options

1602: set profile_option_value = to_char(bom_attr1)
1603: where application_id = 724
1604: and level_id = 10001
1605: and profile_option_id = (select profile_option_id
1606: from fnd_profile_options
1607: where application_id = 724
1608: and profile_option_name = 'MSC_BATCHABLE_FLAG');
1609:
1610: END IF;

Line 1667: from fnd_profile_options

1663: set profile_option_value = to_char(bom_attr2)
1664: where application_id = 724
1665: and level_id = 10001
1666: and profile_option_id = (select profile_option_id
1667: from fnd_profile_options
1668: where application_id = 724
1669: and profile_option_name = 'MSC_BATCHING_WINDOW');
1670:
1671: END IF;

Line 1726: from fnd_profile_options

1722: set profile_option_value = to_char(bom_attr3)
1723: where application_id = 724
1724: and level_id = 10001
1725: and profile_option_id = (select profile_option_id
1726: from fnd_profile_options
1727: where application_id = 724
1728: and profile_option_name = 'MSC_MIN_CAPACITY');
1729:
1730: END IF;

Line 1785: from fnd_profile_options

1781: set profile_option_value = to_char(bom_attr4)
1782: where application_id = 724
1783: and level_id = 10001
1784: and profile_option_id = (select profile_option_id
1785: from fnd_profile_options
1786: where application_id = 724
1787: and profile_option_name = 'MSC_MAX_CAPACITY');
1788:
1789: END IF;

Line 1844: from fnd_profile_options

1840: set profile_option_value = to_char(bom_attr5)
1841: where application_id = 724
1842: and level_id = 10001
1843: and profile_option_id = (select profile_option_id
1844: from fnd_profile_options
1845: where application_id = 724
1846: and profile_option_name = 'MSC_UNIT_OF_MEASURE');
1847:
1848: END IF;

Line 1955: from fnd_profile_options

1951: set profile_option_value = to_char(fcst_attr1)
1952: where application_id = 724
1953: and level_id = 10001
1954: and profile_option_id = (select profile_option_id
1955: from fnd_profile_options
1956: where application_id = 724
1957: and profile_option_name = 'MSC_FCST_PRIORITY_FLEX_NUM');
1958:
1959: END IF;