DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on FND_PROFILE

Line 613: to_number(Fnd_Profile.Value('USER_ID')),

609: COLLATERAL_FLAG,
610: COSTING_ENABLED_FLAG,
611: decode(x_master_org,X_org_id,COST_OF_SALES_ACCOUNT,X_cost_of_sales_account), -- Bug 4466566
612: COVERAGE_SCHEDULE_ID,
613: to_number(Fnd_Profile.Value('USER_ID')),
614: SYSDATE,
615: CUMULATIVE_TOTAL_LEAD_TIME,
616: CUM_MANUFACTURING_LEAD_TIME,
617: CUSTOMER_ORDER_ENABLED_FLAG,

Line 659: to_number(Fnd_Profile.Value('USER_ID')),

655: INVOICE_ENABLED_FLAG,
656: INVOICING_RULE_ID,
657: ITEM_CATALOG_GROUP_ID,
658: ITEM_TYPE,
659: to_number(Fnd_Profile.Value('USER_ID')),
660: SYSDATE,
661: to_number(Fnd_Profile.Value('LOGIN_ID')),
662: LEAD_TIME_LOT_SIZE,
663: LIST_PRICE_PER_UNIT,

Line 661: to_number(Fnd_Profile.Value('LOGIN_ID')),

657: ITEM_CATALOG_GROUP_ID,
658: ITEM_TYPE,
659: to_number(Fnd_Profile.Value('USER_ID')),
660: SYSDATE,
661: to_number(Fnd_Profile.Value('LOGIN_ID')),
662: LEAD_TIME_LOT_SIZE,
663: LIST_PRICE_PER_UNIT,
664: LOCATION_CONTROL_CODE,
665: LOT_CONTROL_CODE,

Line 963: to_number(Fnd_Profile.Value('USER_ID')),

959: L.LANGUAGE_CODE,
960: userenv('LANG'),
961: X_mfg_description,
962: sysdate,
963: to_number(Fnd_Profile.Value('USER_ID')),
964: sysdate,
965: to_number(Fnd_Profile.Value('USER_ID')),
966: to_number(Fnd_Profile.Value('LOGIN_ID')),
967: X_long_description /* Bug 7591561 */

Line 965: to_number(Fnd_Profile.Value('USER_ID')),

961: X_mfg_description,
962: sysdate,
963: to_number(Fnd_Profile.Value('USER_ID')),
964: sysdate,
965: to_number(Fnd_Profile.Value('USER_ID')),
966: to_number(Fnd_Profile.Value('LOGIN_ID')),
967: X_long_description /* Bug 7591561 */
968:
969: from FND_LANGUAGES L

Line 966: to_number(Fnd_Profile.Value('LOGIN_ID')),

962: sysdate,
963: to_number(Fnd_Profile.Value('USER_ID')),
964: sysdate,
965: to_number(Fnd_Profile.Value('USER_ID')),
966: to_number(Fnd_Profile.Value('LOGIN_ID')),
967: X_long_description /* Bug 7591561 */
968:
969: from FND_LANGUAGES L
970: where L.INSTALLED_FLAG in ('I', 'B')

Line 1014: to_number(Fnd_Profile.Value('USER_ID')),

1010: REQUEST_ID)
1011: SELECT
1012: CATEGORY_ID,
1013: CATEGORY_SET_ID,
1014: to_number(Fnd_Profile.Value('USER_ID')),
1015: SYSDATE,
1016: X_mfg_item_id,
1017: to_number(Fnd_Profile.Value('USER_ID')),
1018: SYSDATE,

Line 1017: to_number(Fnd_Profile.Value('USER_ID')),

1013: CATEGORY_SET_ID,
1014: to_number(Fnd_Profile.Value('USER_ID')),
1015: SYSDATE,
1016: X_mfg_item_id,
1017: to_number(Fnd_Profile.Value('USER_ID')),
1018: SYSDATE,
1019: to_number(Fnd_Profile.Value('LOGIN_ID')),
1020: X_master_org,
1021: PROGRAM_APPLICATION_ID,

Line 1019: to_number(Fnd_Profile.Value('LOGIN_ID')),

1015: SYSDATE,
1016: X_mfg_item_id,
1017: to_number(Fnd_Profile.Value('USER_ID')),
1018: SYSDATE,
1019: to_number(Fnd_Profile.Value('LOGIN_ID')),
1020: X_master_org,
1021: PROGRAM_APPLICATION_ID,
1022: PROGRAM_ID,
1023: PROGRAM_UPDATE_DATE,

Line 1066: to_number(Fnd_Profile.Value('USER_ID')),

1062: PROGRAM_ID,
1063: PROGRAM_UPDATE_DATE,
1064: REQUEST_ID)
1065: SELECT
1066: to_number(Fnd_Profile.Value('USER_ID')),
1067: SYSDATE,
1068: DEFAULT_ELEMENT_FLAG,
1069: ELEMENT_NAME,
1070: ELEMENT_SEQUENCE,

Line 1073: to_number(Fnd_Profile.Value('USER_ID')),

1069: ELEMENT_NAME,
1070: ELEMENT_SEQUENCE,
1071: ELEMENT_VALUE,
1072: X_mfg_item_id,
1073: to_number(Fnd_Profile.Value('USER_ID')),
1074: SYSDATE,
1075: to_number(Fnd_Profile.Value('LOGIN_ID')),
1076: PROGRAM_APPLICATION_ID,
1077: PROGRAM_ID,

Line 1075: to_number(Fnd_Profile.Value('LOGIN_ID')),

1071: ELEMENT_VALUE,
1072: X_mfg_item_id,
1073: to_number(Fnd_Profile.Value('USER_ID')),
1074: SYSDATE,
1075: to_number(Fnd_Profile.Value('LOGIN_ID')),
1076: PROGRAM_APPLICATION_ID,
1077: PROGRAM_ID,
1078: PROGRAM_UPDATE_DATE,
1079: REQUEST_ID

Line 1120: to_number(Fnd_Profile.Value('USER_ID')),

1116: RELATED_ITEM_ID,
1117: RELATIONSHIP_TYPE_ID,
1118: REQUEST_ID)
1119: SELECT
1120: to_number(Fnd_Profile.Value('USER_ID')),
1121: SYSDATE,
1122: X_mfg_item_id,
1123: to_number(Fnd_Profile.Value('USER_ID')),
1124: SYSDATE,

Line 1123: to_number(Fnd_Profile.Value('USER_ID')),

1119: SELECT
1120: to_number(Fnd_Profile.Value('USER_ID')),
1121: SYSDATE,
1122: X_mfg_item_id,
1123: to_number(Fnd_Profile.Value('USER_ID')),
1124: SYSDATE,
1125: to_number(Fnd_Profile.Value('LOGIN_ID')),
1126: X_master_org,
1127: PROGRAM_APPLICATION_ID,

Line 1125: to_number(Fnd_Profile.Value('LOGIN_ID')),

1121: SYSDATE,
1122: X_mfg_item_id,
1123: to_number(Fnd_Profile.Value('USER_ID')),
1124: SYSDATE,
1125: to_number(Fnd_Profile.Value('LOGIN_ID')),
1126: X_master_org,
1127: PROGRAM_APPLICATION_ID,
1128: PROGRAM_ID,
1129: PROGRAM_UPDATE_DATE,

Line 1235: to_number(Fnd_Profile.Value('USER_ID')),

1231: BASED_ON_ROLLUP_FLAG,
1232: BURDEN_COST,
1233: COST_TYPE_ID,
1234: COST_UPDATE_ID,
1235: to_number(Fnd_Profile.Value('USER_ID')),
1236: SYSDATE,
1237: DEFAULTED_FLAG,
1238: INVENTORY_ASSET_FLAG,
1239: X_mfg_item_id,

Line 1241: to_number(Fnd_Profile.Value('USER_ID')),

1237: DEFAULTED_FLAG,
1238: INVENTORY_ASSET_FLAG,
1239: X_mfg_item_id,
1240: ITEM_COST,
1241: to_number(Fnd_Profile.Value('USER_ID')),
1242: SYSDATE,
1243: to_number(Fnd_Profile.Value('LOGIN_ID')),
1244: LOT_SIZE,
1245: MATERIAL_COST,

Line 1243: to_number(Fnd_Profile.Value('LOGIN_ID')),

1239: X_mfg_item_id,
1240: ITEM_COST,
1241: to_number(Fnd_Profile.Value('USER_ID')),
1242: SYSDATE,
1243: to_number(Fnd_Profile.Value('LOGIN_ID')),
1244: LOT_SIZE,
1245: MATERIAL_COST,
1246: MATERIAL_OVERHEAD_COST,
1247: X_master_org,

Line 1367: to_number(Fnd_Profile.Value('USER_ID')),

1363: BASIS_RESOURCE_ID,
1364: BASIS_TYPE,
1365: COST_ELEMENT_ID,
1366: COST_TYPE_ID,
1367: to_number(Fnd_Profile.Value('USER_ID')),
1368: SYSDATE,
1369: DEPARTMENT_ID,
1370: X_mfg_item_id,
1371: ITEM_COST,

Line 1373: to_number(Fnd_Profile.Value('USER_ID')),

1369: DEPARTMENT_ID,
1370: X_mfg_item_id,
1371: ITEM_COST,
1372: ITEM_UNITS,
1373: to_number(Fnd_Profile.Value('USER_ID')),
1374: SYSDATE,
1375: to_number(Fnd_Profile.Value('LOGIN_ID')),
1376: LEVEL_TYPE,
1377: NET_YIELD_OR_SHRINKAGE_FACTOR,

Line 1375: to_number(Fnd_Profile.Value('LOGIN_ID')),

1371: ITEM_COST,
1372: ITEM_UNITS,
1373: to_number(Fnd_Profile.Value('USER_ID')),
1374: SYSDATE,
1375: to_number(Fnd_Profile.Value('LOGIN_ID')),
1376: LEVEL_TYPE,
1377: NET_YIELD_OR_SHRINKAGE_FACTOR,
1378: OPERATION_SEQUENCE_ID,
1379: OPERATION_SEQ_NUM,

Line 1476: to_number(Fnd_Profile.Value('USER_ID')),

1472: ATTRIBUTE7,
1473: ATTRIBUTE8,
1474: ATTRIBUTE9,
1475: ATTRIBUTE_CATEGORY,
1476: to_number(Fnd_Profile.Value('USER_ID')),
1477: SYSDATE,
1478: ENCUMBRANCE_ACCOUNT,
1479: FIXED_LOT_MULTIPLE,
1480: X_mfg_item_id,

Line 1482: to_number(Fnd_Profile.Value('USER_ID')),

1478: ENCUMBRANCE_ACCOUNT,
1479: FIXED_LOT_MULTIPLE,
1480: X_mfg_item_id,
1481: INVENTORY_PLANNING_CODE,
1482: to_number(Fnd_Profile.Value('USER_ID')),
1483: SYSDATE,
1484: to_number(Fnd_Profile.Value('LOGIN_ID')),
1485: MAXIMUM_ORDER_QUANTITY,
1486: MAX_MINMAX_QUANTITY,

Line 1484: to_number(Fnd_Profile.Value('LOGIN_ID')),

1480: X_mfg_item_id,
1481: INVENTORY_PLANNING_CODE,
1482: to_number(Fnd_Profile.Value('USER_ID')),
1483: SYSDATE,
1484: to_number(Fnd_Profile.Value('LOGIN_ID')),
1485: MAXIMUM_ORDER_QUANTITY,
1486: MAX_MINMAX_QUANTITY,
1487: MINIMUM_ORDER_QUANTITY,
1488: MIN_MINMAX_QUANTITY,

Line 1545: to_number(Fnd_Profile.Value('USER_ID')),

1541: SUBINVENTORY_CODE,
1542: STATUS_ID,
1543: MAXIMUM_QUANTITY)
1544: SELECT
1545: to_number(Fnd_Profile.Value('USER_ID')),
1546: SYSDATE,
1547: X_mfg_item_id,
1548: to_number(Fnd_Profile.Value('USER_ID')),
1549: SYSDATE,

Line 1548: to_number(Fnd_Profile.Value('USER_ID')),

1544: SELECT
1545: to_number(Fnd_Profile.Value('USER_ID')),
1546: SYSDATE,
1547: X_mfg_item_id,
1548: to_number(Fnd_Profile.Value('USER_ID')),
1549: SYSDATE,
1550: to_number(Fnd_Profile.Value('LOGIN_ID')),
1551: X_master_org,
1552: PICKING_ORDER,

Line 1550: to_number(Fnd_Profile.Value('LOGIN_ID')),

1546: SYSDATE,
1547: X_mfg_item_id,
1548: to_number(Fnd_Profile.Value('USER_ID')),
1549: SYSDATE,
1550: to_number(Fnd_Profile.Value('LOGIN_ID')),
1551: X_master_org,
1552: PICKING_ORDER,
1553: PRIMARY_LOCATOR_FLAG,
1554: PROGRAM_APPLICATION_ID,

Line 1706: to_number(Fnd_Profile.Value('USER_ID')),

1702: PROGRAM_UPDATE_DATE,
1703: REQUEST_ID,
1704: STATUS_CODE)
1705: SELECT
1706: to_number(Fnd_Profile.Value('USER_ID')),
1707: SYSDATE,
1708: EFFECTIVE_DATE,
1709: IMPLEMENTED_DATE,
1710: X_mfg_item_id,

Line 1711: to_number(Fnd_Profile.Value('USER_ID')),

1707: SYSDATE,
1708: EFFECTIVE_DATE,
1709: IMPLEMENTED_DATE,
1710: X_mfg_item_id,
1711: to_number(Fnd_Profile.Value('USER_ID')),
1712: SYSDATE,
1713: to_number(Fnd_Profile.Value('LOGIN_ID')),
1714: X_master_org,
1715: PENDING_FLAG,

Line 1713: to_number(Fnd_Profile.Value('LOGIN_ID')),

1709: IMPLEMENTED_DATE,
1710: X_mfg_item_id,
1711: to_number(Fnd_Profile.Value('USER_ID')),
1712: SYSDATE,
1713: to_number(Fnd_Profile.Value('LOGIN_ID')),
1714: X_master_org,
1715: PENDING_FLAG,
1716: PROGRAM_APPLICATION_ID,
1717: PROGRAM_ID,

Line 1770: to_number(Fnd_Profile.Value('USER_ID')),

1766: WIP_ADJUSTMENT_QUANTITY,
1767: WIP_ADJUSTMENT_VALUE)
1768: SELECT
1769: COST_UPDATE_ID,
1770: to_number(Fnd_Profile.Value('USER_ID')),
1771: SYSDATE,
1772: INTRANSIT_ADJUSTMENT_QUANTITY,
1773: INTRANSIT_ADJUSTMENT_VALUE,
1774: INVENTORY_ADJUSTMENT_QUANTITY,

Line 1778: to_number(Fnd_Profile.Value('USER_ID')),

1774: INVENTORY_ADJUSTMENT_QUANTITY,
1775: INVENTORY_ADJUSTMENT_VALUE,
1776: X_mfg_item_id,
1777: LAST_COST_UPDATE_ID,
1778: to_number(Fnd_Profile.Value('USER_ID')),
1779: SYSDATE,
1780: to_number(Fnd_Profile.Value('LOGIN_ID')),
1781: X_master_org,
1782: PROGRAM_APPLICATION_ID,

Line 1780: to_number(Fnd_Profile.Value('LOGIN_ID')),

1776: X_mfg_item_id,
1777: LAST_COST_UPDATE_ID,
1778: to_number(Fnd_Profile.Value('USER_ID')),
1779: SYSDATE,
1780: to_number(Fnd_Profile.Value('LOGIN_ID')),
1781: X_master_org,
1782: PROGRAM_APPLICATION_ID,
1783: PROGRAM_ID,
1784: PROGRAM_UPDATE_DATE,

Line 1833: to_number(Fnd_Profile.Value('USER_ID')),

1829: STANDARD_COST)
1830: SELECT
1831: COST_ELEMENT_ID,
1832: COST_UPDATE_ID,
1833: to_number(Fnd_Profile.Value('USER_ID')),
1834: SYSDATE,
1835: X_mfg_item_id,
1836: to_number(Fnd_Profile.Value('USER_ID')),
1837: SYSDATE,

Line 1836: to_number(Fnd_Profile.Value('USER_ID')),

1832: COST_UPDATE_ID,
1833: to_number(Fnd_Profile.Value('USER_ID')),
1834: SYSDATE,
1835: X_mfg_item_id,
1836: to_number(Fnd_Profile.Value('USER_ID')),
1837: SYSDATE,
1838: to_number(Fnd_Profile.Value('LOGIN_ID')),
1839: X_master_org,
1840: PROGRAM_APPLICATION_ID,

Line 1838: to_number(Fnd_Profile.Value('LOGIN_ID')),

1834: SYSDATE,
1835: X_mfg_item_id,
1836: to_number(Fnd_Profile.Value('USER_ID')),
1837: SYSDATE,
1838: to_number(Fnd_Profile.Value('LOGIN_ID')),
1839: X_master_org,
1840: PROGRAM_APPLICATION_ID,
1841: PROGRAM_ID,
1842: PROGRAM_UPDATE_DATE,