DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on STANDARD

Line 1719: PROCEDURE C_CST_STANDARD_COSTS (

1715: token => SQLERRM);
1716:
1717: END C_MTL_PENDING_ITEM_STATUS;
1718:
1719: PROCEDURE C_CST_STANDARD_COSTS (
1720: X_org_id IN NUMBER,
1721: X_master_org IN NUMBER,
1722: X_eng_item_id IN NUMBER,
1723: X_mfg_item_id IN NUMBER,

Line 1731: INSERT INTO CST_STANDARD_COSTS(

1727: )
1728: IS
1729: BEGIN
1730:
1731: INSERT INTO CST_STANDARD_COSTS(
1732: COST_UPDATE_ID,
1733: CREATED_BY,
1734: CREATION_DATE,
1735: INTRANSIT_ADJUSTMENT_QUANTITY,

Line 1749: STANDARD_COST,

1745: PROGRAM_APPLICATION_ID,
1746: PROGRAM_ID,
1747: PROGRAM_UPDATE_DATE,
1748: REQUEST_ID,
1749: STANDARD_COST,
1750: STANDARD_COST_REVISION_DATE,
1751: WIP_ADJUSTMENT_QUANTITY,
1752: WIP_ADJUSTMENT_VALUE)
1753: SELECT

Line 1750: STANDARD_COST_REVISION_DATE,

1746: PROGRAM_ID,
1747: PROGRAM_UPDATE_DATE,
1748: REQUEST_ID,
1749: STANDARD_COST,
1750: STANDARD_COST_REVISION_DATE,
1751: WIP_ADJUSTMENT_QUANTITY,
1752: WIP_ADJUSTMENT_VALUE)
1753: SELECT
1754: COST_UPDATE_ID,

Line 1771: STANDARD_COST,

1767: PROGRAM_APPLICATION_ID,
1768: PROGRAM_ID,
1769: PROGRAM_UPDATE_DATE,
1770: REQUEST_ID,
1771: STANDARD_COST,
1772: STANDARD_COST_REVISION_DATE,
1773: WIP_ADJUSTMENT_QUANTITY,
1774: WIP_ADJUSTMENT_VALUE
1775: FROM CST_STANDARD_COSTS

Line 1772: STANDARD_COST_REVISION_DATE,

1768: PROGRAM_ID,
1769: PROGRAM_UPDATE_DATE,
1770: REQUEST_ID,
1771: STANDARD_COST,
1772: STANDARD_COST_REVISION_DATE,
1773: WIP_ADJUSTMENT_QUANTITY,
1774: WIP_ADJUSTMENT_VALUE
1775: FROM CST_STANDARD_COSTS
1776: WHERE INVENTORY_ITEM_ID = X_eng_item_id

Line 1775: FROM CST_STANDARD_COSTS

1771: STANDARD_COST,
1772: STANDARD_COST_REVISION_DATE,
1773: WIP_ADJUSTMENT_QUANTITY,
1774: WIP_ADJUSTMENT_VALUE
1775: FROM CST_STANDARD_COSTS
1776: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1777: AND ORGANIZATION_ID = X_org_id;
1778:
1779: EXCEPTION

Line 1781: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',

1777: AND ORGANIZATION_ID = X_org_id;
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',
1782: stmt_num => 1012,
1783: message_name => 'ENG_ENUBRT_ERROR',
1784: token => SQLERRM);
1785:

Line 1786: END C_CST_STANDARD_COSTS;

1782: stmt_num => 1012,
1783: message_name => 'ENG_ENUBRT_ERROR',
1784: token => SQLERRM);
1785:
1786: END C_CST_STANDARD_COSTS;
1787:
1788: PROCEDURE C_CST_ELEMENTAL_COSTS (
1789: X_org_id IN NUMBER,
1790: X_master_org IN NUMBER,

Line 1814: STANDARD_COST)

1810: PROGRAM_APPLICATION_ID,
1811: PROGRAM_ID,
1812: PROGRAM_UPDATE_DATE,
1813: REQUEST_ID,
1814: STANDARD_COST)
1815: SELECT
1816: COST_ELEMENT_ID,
1817: COST_UPDATE_ID,
1818: to_number(Fnd_Profile.Value('USER_ID')),

Line 1829: STANDARD_COST

1825: PROGRAM_APPLICATION_ID,
1826: PROGRAM_ID,
1827: PROGRAM_UPDATE_DATE,
1828: REQUEST_ID,
1829: STANDARD_COST
1830: FROM CST_ELEMENTAL_COSTS
1831: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1832: AND ORGANIZATION_ID = X_org_id;
1833: