DBA Data[Home] [Help]

APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on STANDARD

Line 1734: PROCEDURE C_CST_STANDARD_COSTS (

1730: token => SQLERRM);
1731:
1732: END C_MTL_PENDING_ITEM_STATUS;
1733:
1734: PROCEDURE C_CST_STANDARD_COSTS (
1735: X_org_id IN NUMBER,
1736: X_master_org IN NUMBER,
1737: X_eng_item_id IN NUMBER,
1738: X_mfg_item_id IN NUMBER,

Line 1746: INSERT INTO CST_STANDARD_COSTS(

1742: )
1743: IS
1744: BEGIN
1745:
1746: INSERT INTO CST_STANDARD_COSTS(
1747: COST_UPDATE_ID,
1748: CREATED_BY,
1749: CREATION_DATE,
1750: INTRANSIT_ADJUSTMENT_QUANTITY,

Line 1764: STANDARD_COST,

1760: PROGRAM_APPLICATION_ID,
1761: PROGRAM_ID,
1762: PROGRAM_UPDATE_DATE,
1763: REQUEST_ID,
1764: STANDARD_COST,
1765: STANDARD_COST_REVISION_DATE,
1766: WIP_ADJUSTMENT_QUANTITY,
1767: WIP_ADJUSTMENT_VALUE)
1768: SELECT

Line 1765: STANDARD_COST_REVISION_DATE,

1761: PROGRAM_ID,
1762: PROGRAM_UPDATE_DATE,
1763: REQUEST_ID,
1764: STANDARD_COST,
1765: STANDARD_COST_REVISION_DATE,
1766: WIP_ADJUSTMENT_QUANTITY,
1767: WIP_ADJUSTMENT_VALUE)
1768: SELECT
1769: COST_UPDATE_ID,

Line 1786: STANDARD_COST,

1782: PROGRAM_APPLICATION_ID,
1783: PROGRAM_ID,
1784: PROGRAM_UPDATE_DATE,
1785: REQUEST_ID,
1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS

Line 1787: STANDARD_COST_REVISION_DATE,

1783: PROGRAM_ID,
1784: PROGRAM_UPDATE_DATE,
1785: REQUEST_ID,
1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS
1791: WHERE INVENTORY_ITEM_ID = X_eng_item_id

Line 1790: FROM CST_STANDARD_COSTS

1786: STANDARD_COST,
1787: STANDARD_COST_REVISION_DATE,
1788: WIP_ADJUSTMENT_QUANTITY,
1789: WIP_ADJUSTMENT_VALUE
1790: FROM CST_STANDARD_COSTS
1791: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1792: AND ORGANIZATION_ID = X_org_id;
1793:
1794: EXCEPTION

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

1792: AND ORGANIZATION_ID = X_org_id;
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: ENG_BOM_RTG_TRANSFER_PKG.RAISE_ERROR(func_name => 'C_CST_STANDARD_COSTS',
1797: stmt_num => 1012,
1798: message_name => 'ENG_ENUBRT_ERROR',
1799: token => SQLERRM);
1800:

Line 1801: END C_CST_STANDARD_COSTS;

1797: stmt_num => 1012,
1798: message_name => 'ENG_ENUBRT_ERROR',
1799: token => SQLERRM);
1800:
1801: END C_CST_STANDARD_COSTS;
1802:
1803: PROCEDURE C_CST_ELEMENTAL_COSTS (
1804: X_org_id IN NUMBER,
1805: X_master_org IN NUMBER,

Line 1829: STANDARD_COST)

1825: PROGRAM_APPLICATION_ID,
1826: PROGRAM_ID,
1827: PROGRAM_UPDATE_DATE,
1828: REQUEST_ID,
1829: STANDARD_COST)
1830: SELECT
1831: COST_ELEMENT_ID,
1832: COST_UPDATE_ID,
1833: to_number(Fnd_Profile.Value('USER_ID')),

Line 1844: STANDARD_COST

1840: PROGRAM_APPLICATION_ID,
1841: PROGRAM_ID,
1842: PROGRAM_UPDATE_DATE,
1843: REQUEST_ID,
1844: STANDARD_COST
1845: FROM CST_ELEMENTAL_COSTS
1846: WHERE INVENTORY_ITEM_ID = X_eng_item_id
1847: AND ORGANIZATION_ID = X_org_id;
1848: