DBA Data[Home] [Help]

APPS.MSC_CONFIG_FF dependencies on FND_PROFILE_OPTION_VALUES

Line 316: update fnd_profile_option_values

312: window_prompt => 'Late Demands Penalty',
313: range => NULL,
314: srw_parameter => NULL);
315:
316: update fnd_profile_option_values
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

Line 381: update fnd_profile_option_values

377: window_prompt => 'Material Over-Capacity Penalty',
378: range => NULL,
379: srw_parameter => NULL);
380:
381: update fnd_profile_option_values
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

Line 451: update fnd_profile_option_values

447: window_prompt => 'Late Demands Penalty',
448: range => NULL,
449: srw_parameter => NULL);
450:
451: update fnd_profile_option_values
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

Line 516: update fnd_profile_option_values

512: window_prompt => 'Material Over-Capacity Penalty',
513: range => NULL,
514: srw_parameter => NULL);
515:
516: update fnd_profile_option_values
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

Line 582: update fnd_profile_option_values

578: window_prompt => 'Resource Over-Capacity Penalty',
579: range => NULL,
580: srw_parameter => NULL);
581:
582: update fnd_profile_option_values
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

Line 648: update fnd_profile_option_values

644: window_prompt => 'Transport Over-Cap Penalty',
645: range => NULL,
646: srw_parameter => NULL);
647:
648: update fnd_profile_option_values
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

Line 719: update fnd_profile_option_values

715: window_prompt => 'Aggregate Resource',
716: range => NULL,
717: srw_parameter => NULL);
718:
719: update fnd_profile_option_values
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

Line 792: update fnd_profile_option_values

788: window_prompt => 'Resource Over-Capacity Penalty',
789: range => NULL,
790: srw_parameter => NULL);
791:
792: update fnd_profile_option_values
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

Line 862: update fnd_profile_option_values

858: window_prompt => 'Material Over-Capacity Penalty',
859: range => NULL,
860: srw_parameter => NULL);
861:
862: update fnd_profile_option_values
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

Line 933: update fnd_profile_option_values

929: window_prompt => 'Substitute Priority',
930: range => NULL,
931: srw_parameter => NULL);
932:
933: update fnd_profile_option_values
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

Line 1004: update fnd_profile_option_values

1000: window_prompt => 'Transport Over-Cap Penalty',
1001: range => NULL,
1002: srw_parameter => NULL);
1003:
1004: update fnd_profile_option_values
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

Line 1075: update fnd_profile_option_values

1071: window_prompt => 'Cost of Using a BOM/Routing',
1072: range => NULL,
1073: srw_parameter => NULL);
1074:
1075: update fnd_profile_option_values
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

Line 1146: update fnd_profile_option_values

1142: window_prompt => 'Late Forecasts Penalty',
1143: range => NULL,
1144: srw_parameter => NULL);
1145:
1146: update fnd_profile_option_values
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

Line 1216: update fnd_profile_option_values

1212: window_prompt => 'Resource Group',
1213: range => NULL,
1214: srw_parameter => NULL);
1215:
1216: update fnd_profile_option_values
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

Line 1281: update fnd_profile_option_values

1277: window_prompt => 'Demand Priority',
1278: range => NULL,
1279: srw_parameter => NULL);
1280:
1281: update fnd_profile_option_values
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

Line 1601: update fnd_profile_option_values

1597: window_prompt => 'Batchable Flag',
1598: range => NULL,
1599: srw_parameter => NULL);
1600:
1601: update fnd_profile_option_values
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

Line 1662: update fnd_profile_option_values

1658: window_prompt => 'Batching Window',
1659: range => NULL,
1660: srw_parameter => NULL);
1661:
1662: update fnd_profile_option_values
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

Line 1721: update fnd_profile_option_values

1717: window_prompt => 'Minimum Batch Capacity',
1718: range => NULL,
1719: srw_parameter => NULL);
1720:
1721: update fnd_profile_option_values
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

Line 1780: update fnd_profile_option_values

1776: window_prompt => 'Maximum Batch Capacity',
1777: range => NULL,
1778: srw_parameter => NULL);
1779:
1780: update fnd_profile_option_values
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

Line 1839: update fnd_profile_option_values

1835: window_prompt => 'Batchable Unit of Measure',
1836: range => NULL,
1837: srw_parameter => NULL);
1838:
1839: update fnd_profile_option_values
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

Line 1950: update fnd_profile_option_values

1946: window_prompt => 'Forecast Priority',
1947: range => NULL,
1948: srw_parameter => NULL);
1949:
1950: update fnd_profile_option_values
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