[Home] [Help]
1759: ,1
1760: ,'Y'
1761: ,'N')
1762: FROM
1763: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1764: WHERE PAWO.INV_TRANSACTION_ID = PART.INV_TRANSACTION_ID
1765: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1766: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1767: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1774: SELECT
1775: PART1.ROWID
1776: FROM
1777: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1778: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1779: WHERE PAWO.INV_TRANSACTION_ID = PART1.INV_TRANSACTION_ID
1780: AND PART1.COST_TYPE_ID = P_COST_TYPE
1781: AND PART1.COST_GROUP_ID = P_COST_GROUP
1782: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1798: ,1
1799: ,'Y'
1800: ,'N')
1801: FROM
1802: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1803: WHERE PAWO.WIP_TRANSACTION_ID = PART.WIP_TRANSACTION_ID
1804: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1805: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1806: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1813: SELECT
1814: PART1.ROWID
1815: FROM
1816: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1817: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1818: WHERE PAWO.WIP_TRANSACTION_ID = PART1.WIP_TRANSACTION_ID
1819: AND PART1.COST_TYPE_ID = P_COST_TYPE
1820: AND PART1.COST_GROUP_ID = P_COST_GROUP
1821: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1837: ,1
1838: ,'Y'
1839: ,'N')
1840: FROM
1841: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1842: WHERE PAWO.PO_TRANSACTION_ID = PART.PO_TRANSACTION_ID
1843: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1844: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1845: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1852: SELECT
1853: PART1.ROWID
1854: FROM
1855: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1856: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1857: WHERE PAWO.PO_TRANSACTION_ID = PART1.PO_TRANSACTION_ID
1858: AND PART1.COST_TYPE_ID = P_COST_TYPE
1859: AND PART1.COST_GROUP_ID = P_COST_GROUP
1860: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY
1876: ,1
1877: ,'Y'
1878: ,'N')
1879: FROM
1880: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1881: WHERE PAWO.INVOICE_ID = PART.INVOICE_ID
1882: AND PAWO.INVOICE_LINE_NUM = PART.INVOICE_LINE_NUM
1883: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1884: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1893: SELECT
1894: PART1.ROWID
1895: FROM
1896: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1897: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1898: WHERE PAWO.INVOICE_ID = PART1.INVOICE_ID
1899: AND PAWO.INVOICE_LINE_NUM = PART1.INVOICE_LINE_NUM
1900: AND PART1.COST_TYPE_ID = P_COST_TYPE
1901: AND PART1.COST_GROUP_ID = P_COST_GROUP