DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on FND_PROFILE

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

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

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

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

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

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

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

946: L.LANGUAGE_CODE,
947: userenv('LANG'),
948: X_mfg_description,
949: sysdate,
950: to_number(Fnd_Profile.Value('USER_ID')),
951: sysdate,
952: to_number(Fnd_Profile.Value('USER_ID')),
953: to_number(Fnd_Profile.Value('LOGIN_ID'))
954: from FND_LANGUAGES L

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

948: X_mfg_description,
949: sysdate,
950: to_number(Fnd_Profile.Value('USER_ID')),
951: sysdate,
952: to_number(Fnd_Profile.Value('USER_ID')),
953: to_number(Fnd_Profile.Value('LOGIN_ID'))
954: from FND_LANGUAGES L
955: where L.INSTALLED_FLAG in ('I', 'B')
956: and not exists

Line 953: to_number(Fnd_Profile.Value('LOGIN_ID'))

949: sysdate,
950: to_number(Fnd_Profile.Value('USER_ID')),
951: sysdate,
952: to_number(Fnd_Profile.Value('USER_ID')),
953: to_number(Fnd_Profile.Value('LOGIN_ID'))
954: from FND_LANGUAGES L
955: where L.INSTALLED_FLAG in ('I', 'B')
956: and not exists
957: ( select NULL

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

995: REQUEST_ID)
996: SELECT
997: CATEGORY_ID,
998: CATEGORY_SET_ID,
999: to_number(Fnd_Profile.Value('USER_ID')),
1000: SYSDATE,
1001: X_mfg_item_id,
1002: to_number(Fnd_Profile.Value('USER_ID')),
1003: SYSDATE,

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

998: CATEGORY_SET_ID,
999: to_number(Fnd_Profile.Value('USER_ID')),
1000: SYSDATE,
1001: X_mfg_item_id,
1002: to_number(Fnd_Profile.Value('USER_ID')),
1003: SYSDATE,
1004: to_number(Fnd_Profile.Value('LOGIN_ID')),
1005: X_master_org,
1006: PROGRAM_APPLICATION_ID,

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

1000: SYSDATE,
1001: X_mfg_item_id,
1002: to_number(Fnd_Profile.Value('USER_ID')),
1003: SYSDATE,
1004: to_number(Fnd_Profile.Value('LOGIN_ID')),
1005: X_master_org,
1006: PROGRAM_APPLICATION_ID,
1007: PROGRAM_ID,
1008: PROGRAM_UPDATE_DATE,

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

1047: PROGRAM_ID,
1048: PROGRAM_UPDATE_DATE,
1049: REQUEST_ID)
1050: SELECT
1051: to_number(Fnd_Profile.Value('USER_ID')),
1052: SYSDATE,
1053: DEFAULT_ELEMENT_FLAG,
1054: ELEMENT_NAME,
1055: ELEMENT_SEQUENCE,

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

1054: ELEMENT_NAME,
1055: ELEMENT_SEQUENCE,
1056: ELEMENT_VALUE,
1057: X_mfg_item_id,
1058: to_number(Fnd_Profile.Value('USER_ID')),
1059: SYSDATE,
1060: to_number(Fnd_Profile.Value('LOGIN_ID')),
1061: PROGRAM_APPLICATION_ID,
1062: PROGRAM_ID,

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

1056: ELEMENT_VALUE,
1057: X_mfg_item_id,
1058: to_number(Fnd_Profile.Value('USER_ID')),
1059: SYSDATE,
1060: to_number(Fnd_Profile.Value('LOGIN_ID')),
1061: PROGRAM_APPLICATION_ID,
1062: PROGRAM_ID,
1063: PROGRAM_UPDATE_DATE,
1064: REQUEST_ID

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

1101: RELATED_ITEM_ID,
1102: RELATIONSHIP_TYPE_ID,
1103: REQUEST_ID)
1104: SELECT
1105: to_number(Fnd_Profile.Value('USER_ID')),
1106: SYSDATE,
1107: X_mfg_item_id,
1108: to_number(Fnd_Profile.Value('USER_ID')),
1109: SYSDATE,

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

1104: SELECT
1105: to_number(Fnd_Profile.Value('USER_ID')),
1106: SYSDATE,
1107: X_mfg_item_id,
1108: to_number(Fnd_Profile.Value('USER_ID')),
1109: SYSDATE,
1110: to_number(Fnd_Profile.Value('LOGIN_ID')),
1111: X_master_org,
1112: PROGRAM_APPLICATION_ID,

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

1106: SYSDATE,
1107: X_mfg_item_id,
1108: to_number(Fnd_Profile.Value('USER_ID')),
1109: SYSDATE,
1110: to_number(Fnd_Profile.Value('LOGIN_ID')),
1111: X_master_org,
1112: PROGRAM_APPLICATION_ID,
1113: PROGRAM_ID,
1114: PROGRAM_UPDATE_DATE,

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

1216: BASED_ON_ROLLUP_FLAG,
1217: BURDEN_COST,
1218: COST_TYPE_ID,
1219: COST_UPDATE_ID,
1220: to_number(Fnd_Profile.Value('USER_ID')),
1221: SYSDATE,
1222: DEFAULTED_FLAG,
1223: INVENTORY_ASSET_FLAG,
1224: X_mfg_item_id,

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

1222: DEFAULTED_FLAG,
1223: INVENTORY_ASSET_FLAG,
1224: X_mfg_item_id,
1225: ITEM_COST,
1226: to_number(Fnd_Profile.Value('USER_ID')),
1227: SYSDATE,
1228: to_number(Fnd_Profile.Value('LOGIN_ID')),
1229: LOT_SIZE,
1230: MATERIAL_COST,

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

1224: X_mfg_item_id,
1225: ITEM_COST,
1226: to_number(Fnd_Profile.Value('USER_ID')),
1227: SYSDATE,
1228: to_number(Fnd_Profile.Value('LOGIN_ID')),
1229: LOT_SIZE,
1230: MATERIAL_COST,
1231: MATERIAL_OVERHEAD_COST,
1232: X_master_org,

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

1348: BASIS_RESOURCE_ID,
1349: BASIS_TYPE,
1350: COST_ELEMENT_ID,
1351: COST_TYPE_ID,
1352: to_number(Fnd_Profile.Value('USER_ID')),
1353: SYSDATE,
1354: DEPARTMENT_ID,
1355: X_mfg_item_id,
1356: ITEM_COST,

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

1354: DEPARTMENT_ID,
1355: X_mfg_item_id,
1356: ITEM_COST,
1357: ITEM_UNITS,
1358: to_number(Fnd_Profile.Value('USER_ID')),
1359: SYSDATE,
1360: to_number(Fnd_Profile.Value('LOGIN_ID')),
1361: LEVEL_TYPE,
1362: NET_YIELD_OR_SHRINKAGE_FACTOR,

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

1356: ITEM_COST,
1357: ITEM_UNITS,
1358: to_number(Fnd_Profile.Value('USER_ID')),
1359: SYSDATE,
1360: to_number(Fnd_Profile.Value('LOGIN_ID')),
1361: LEVEL_TYPE,
1362: NET_YIELD_OR_SHRINKAGE_FACTOR,
1363: OPERATION_SEQUENCE_ID,
1364: OPERATION_SEQ_NUM,

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

1457: ATTRIBUTE7,
1458: ATTRIBUTE8,
1459: ATTRIBUTE9,
1460: ATTRIBUTE_CATEGORY,
1461: to_number(Fnd_Profile.Value('USER_ID')),
1462: SYSDATE,
1463: ENCUMBRANCE_ACCOUNT,
1464: FIXED_LOT_MULTIPLE,
1465: X_mfg_item_id,

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

1463: ENCUMBRANCE_ACCOUNT,
1464: FIXED_LOT_MULTIPLE,
1465: X_mfg_item_id,
1466: INVENTORY_PLANNING_CODE,
1467: to_number(Fnd_Profile.Value('USER_ID')),
1468: SYSDATE,
1469: to_number(Fnd_Profile.Value('LOGIN_ID')),
1470: MAXIMUM_ORDER_QUANTITY,
1471: MAX_MINMAX_QUANTITY,

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

1465: X_mfg_item_id,
1466: INVENTORY_PLANNING_CODE,
1467: to_number(Fnd_Profile.Value('USER_ID')),
1468: SYSDATE,
1469: to_number(Fnd_Profile.Value('LOGIN_ID')),
1470: MAXIMUM_ORDER_QUANTITY,
1471: MAX_MINMAX_QUANTITY,
1472: MINIMUM_ORDER_QUANTITY,
1473: MIN_MINMAX_QUANTITY,

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

1526: SUBINVENTORY_CODE,
1527: STATUS_ID,
1528: MAXIMUM_QUANTITY)
1529: SELECT
1530: to_number(Fnd_Profile.Value('USER_ID')),
1531: SYSDATE,
1532: X_mfg_item_id,
1533: to_number(Fnd_Profile.Value('USER_ID')),
1534: SYSDATE,

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

1529: SELECT
1530: to_number(Fnd_Profile.Value('USER_ID')),
1531: SYSDATE,
1532: X_mfg_item_id,
1533: to_number(Fnd_Profile.Value('USER_ID')),
1534: SYSDATE,
1535: to_number(Fnd_Profile.Value('LOGIN_ID')),
1536: X_master_org,
1537: PICKING_ORDER,

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

1531: SYSDATE,
1532: X_mfg_item_id,
1533: to_number(Fnd_Profile.Value('USER_ID')),
1534: SYSDATE,
1535: to_number(Fnd_Profile.Value('LOGIN_ID')),
1536: X_master_org,
1537: PICKING_ORDER,
1538: PRIMARY_LOCATOR_FLAG,
1539: PROGRAM_APPLICATION_ID,

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

1687: PROGRAM_UPDATE_DATE,
1688: REQUEST_ID,
1689: STATUS_CODE)
1690: SELECT
1691: to_number(Fnd_Profile.Value('USER_ID')),
1692: SYSDATE,
1693: EFFECTIVE_DATE,
1694: IMPLEMENTED_DATE,
1695: X_mfg_item_id,

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

1692: SYSDATE,
1693: EFFECTIVE_DATE,
1694: IMPLEMENTED_DATE,
1695: X_mfg_item_id,
1696: to_number(Fnd_Profile.Value('USER_ID')),
1697: SYSDATE,
1698: to_number(Fnd_Profile.Value('LOGIN_ID')),
1699: X_master_org,
1700: PENDING_FLAG,

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

1694: IMPLEMENTED_DATE,
1695: X_mfg_item_id,
1696: to_number(Fnd_Profile.Value('USER_ID')),
1697: SYSDATE,
1698: to_number(Fnd_Profile.Value('LOGIN_ID')),
1699: X_master_org,
1700: PENDING_FLAG,
1701: PROGRAM_APPLICATION_ID,
1702: PROGRAM_ID,

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

1751: WIP_ADJUSTMENT_QUANTITY,
1752: WIP_ADJUSTMENT_VALUE)
1753: SELECT
1754: COST_UPDATE_ID,
1755: to_number(Fnd_Profile.Value('USER_ID')),
1756: SYSDATE,
1757: INTRANSIT_ADJUSTMENT_QUANTITY,
1758: INTRANSIT_ADJUSTMENT_VALUE,
1759: INVENTORY_ADJUSTMENT_QUANTITY,

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

1759: INVENTORY_ADJUSTMENT_QUANTITY,
1760: INVENTORY_ADJUSTMENT_VALUE,
1761: X_mfg_item_id,
1762: LAST_COST_UPDATE_ID,
1763: to_number(Fnd_Profile.Value('USER_ID')),
1764: SYSDATE,
1765: to_number(Fnd_Profile.Value('LOGIN_ID')),
1766: X_master_org,
1767: PROGRAM_APPLICATION_ID,

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

1761: X_mfg_item_id,
1762: LAST_COST_UPDATE_ID,
1763: to_number(Fnd_Profile.Value('USER_ID')),
1764: SYSDATE,
1765: to_number(Fnd_Profile.Value('LOGIN_ID')),
1766: X_master_org,
1767: PROGRAM_APPLICATION_ID,
1768: PROGRAM_ID,
1769: PROGRAM_UPDATE_DATE,

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

1814: STANDARD_COST)
1815: SELECT
1816: COST_ELEMENT_ID,
1817: COST_UPDATE_ID,
1818: to_number(Fnd_Profile.Value('USER_ID')),
1819: SYSDATE,
1820: X_mfg_item_id,
1821: to_number(Fnd_Profile.Value('USER_ID')),
1822: SYSDATE,

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

1817: COST_UPDATE_ID,
1818: to_number(Fnd_Profile.Value('USER_ID')),
1819: SYSDATE,
1820: X_mfg_item_id,
1821: to_number(Fnd_Profile.Value('USER_ID')),
1822: SYSDATE,
1823: to_number(Fnd_Profile.Value('LOGIN_ID')),
1824: X_master_org,
1825: PROGRAM_APPLICATION_ID,

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

1819: SYSDATE,
1820: X_mfg_item_id,
1821: to_number(Fnd_Profile.Value('USER_ID')),
1822: SYSDATE,
1823: to_number(Fnd_Profile.Value('LOGIN_ID')),
1824: X_master_org,
1825: PROGRAM_APPLICATION_ID,
1826: PROGRAM_ID,
1827: PROGRAM_UPDATE_DATE,