DBA Data[Home] [Help]

APPS.BOM_CSTRACCR_XMLP_PKG dependencies on CST_PAC_ACCRUAL_WRITE_OFFS

Line 1758: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1754: ,1
1755: ,'Y'
1756: ,'N')
1757: FROM
1758: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1759: WHERE PAWO.INV_TRANSACTION_ID = PART.INV_TRANSACTION_ID
1760: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1761: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1762: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1773: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1769: SELECT
1770: PART1.ROWID
1771: FROM
1772: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1773: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1774: WHERE PAWO.INV_TRANSACTION_ID = PART1.INV_TRANSACTION_ID
1775: AND PART1.COST_TYPE_ID = P_COST_TYPE
1776: AND PART1.COST_GROUP_ID = P_COST_GROUP
1777: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1797: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1793: ,1
1794: ,'Y'
1795: ,'N')
1796: FROM
1797: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1798: WHERE PAWO.WIP_TRANSACTION_ID = PART.WIP_TRANSACTION_ID
1799: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1800: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1801: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1812: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1808: SELECT
1809: PART1.ROWID
1810: FROM
1811: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1812: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1813: WHERE PAWO.WIP_TRANSACTION_ID = PART1.WIP_TRANSACTION_ID
1814: AND PART1.COST_TYPE_ID = P_COST_TYPE
1815: AND PART1.COST_GROUP_ID = P_COST_GROUP
1816: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1836: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1832: ,1
1833: ,'Y'
1834: ,'N')
1835: FROM
1836: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1837: WHERE PAWO.PO_TRANSACTION_ID = PART.PO_TRANSACTION_ID
1838: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1839: AND PAWO.COST_GROUP_ID = P_COST_GROUP
1840: AND PAWO.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1851: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1847: SELECT
1848: PART1.ROWID
1849: FROM
1850: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1851: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1852: WHERE PAWO.PO_TRANSACTION_ID = PART1.PO_TRANSACTION_ID
1853: AND PART1.COST_TYPE_ID = P_COST_TYPE
1854: AND PART1.COST_GROUP_ID = P_COST_GROUP
1855: AND PART1.LEGAL_ENTITY_ID = P_LEGAL_ENTITY

Line 1875: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1871: ,1
1872: ,'Y'
1873: ,'N')
1874: FROM
1875: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1876: WHERE PAWO.INVOICE_ID = PART.INVOICE_ID
1877: AND PAWO.INVOICE_LINE_NUM = PART.INVOICE_LINE_NUM
1878: AND PAWO.COST_TYPE_ID = P_COST_TYPE
1879: AND PAWO.COST_GROUP_ID = P_COST_GROUP

Line 1892: CST_PAC_ACCRUAL_WRITE_OFFS PAWO

1888: SELECT
1889: PART1.ROWID
1890: FROM
1891: CST_PAC_ACCRUAL_RECONCILE_TEMP PART1,
1892: CST_PAC_ACCRUAL_WRITE_OFFS PAWO
1893: WHERE PAWO.INVOICE_ID = PART1.INVOICE_ID
1894: AND PAWO.INVOICE_LINE_NUM = PART1.INVOICE_LINE_NUM
1895: AND PART1.COST_TYPE_ID = P_COST_TYPE
1896: AND PART1.COST_GROUP_ID = P_COST_GROUP