eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on CST_MGD_MSTR_BOOK_TEMP

Line 116: --| CST_MGD_MSTR_BOOK_TEMP |

112: --| Get_Acct_Period_Id_invmbk modified |
113: --| NOTE:Get_Acct_Period_id and Get_Acct_ |
114: --| Period_Id_invmbk are not used anywhere |
115: --| 02/17/2006 vmutyala Bug # 4086259 Added Creation_date to |
116: --| CST_MGD_MSTR_BOOK_TEMP |
117: --| 02/24/2006 vmutyala Bug # 4912772 Performance issue in the |
118: --| dynamic query in Create_Inv_Msbk_Rpt is|
119: --| resolved by restructuring the query |
120: --| 10/27/2008 vjavli FP Bug 7458643 fix:Standard cost update|

Line 249: INSERT INTO cst_mgd_mstr_book_temp (

245: PROCEDURE insert_rpt_data (p_rpt_item_rec IN report_rec_type)
246: IS
247: BEGIN
248:
249: INSERT INTO cst_mgd_mstr_book_temp (
250: transaction_id
251: ,organization_id
252: ,inventory_item_id
253: ,uom_code -- added for inv book

Line 1364: FROM cst_mgd_mstr_book_temp CMIAKD

1360: ,CMIAKD.txn_date TXN_DATE
1361: ,CMIAKD.txn_ini_qty TXN_INI_QTY
1362: ,ROUND(CMIAKD.txn_ini_unit_cost, 2) * CMIAKD.txn_ini_qty TXN_INI_VALUE
1363: ,CMIAKD.organization_id ORGANIZATION_ID
1364: FROM cst_mgd_mstr_book_temp CMIAKD
1365: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1366: AND CMIAKD.organization_id = p_org_id
1367: AND p_break_by = 1
1368: ORDER BY 5, 2, 1 ASC;

Line 1375: FROM cst_mgd_mstr_book_temp

1371:
1372: CURSOR lcu_org
1373: IS
1374: SELECT DISTINCT organization_id
1375: FROM cst_mgd_mstr_book_temp
1376: WHERE inventory_item_id = p_inventory_item_id
1377: ORDER BY organization_id ASC;
1378:
1379: BEGIN

Line 1428: FROM cst_mgd_mstr_book_temp CMIAKD

1424: ,CMIAKD.txn_date TXN_DATE
1425: ,CMIAKD.txn_qty TXN_FNL_QTY
1426: ,ROUND(CMIAKD.txn_unit_cost, 2) * CMIAKD.txn_qty TXN_FNL_VALUE
1427: ,CMIAKD.organization_id ORGANIZATION_ID
1428: FROM cst_mgd_mstr_book_temp CMIAKD
1429: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1430: AND CMIAKD.organization_id = p_org_id
1431: AND p_break_by = 1
1432: ORDER BY 5, 2, 1 ASC;

Line 1437: FROM cst_mgd_mstr_book_temp

1433:
1434: CURSOR lcu_org
1435: IS
1436: SELECT DISTINCT organization_id
1437: FROM cst_mgd_mstr_book_temp
1438: WHERE inventory_item_id = p_inventory_item_id
1439: ORDER BY organization_id ASC;
1440:
1441: BEGIN

Line 1499: FROM cst_mgd_mstr_book_temp CMIAKD

1495: ,CMIAKD.txn_date TXN_DATE
1496: ,CMIAKD.txn_ini_qty TXN_INI_QTY
1497: ,ROUND(CMIAKD.txn_ini_unit_cost, 2) * CMIAKD.txn_ini_qty TXN_INI_VALUE
1498: ,CMIAKD.organization_id ORGANIZATION_ID
1499: FROM cst_mgd_mstr_book_temp CMIAKD
1500: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1501: AND CMIAKD.organization_id = p_org_id
1502: AND p_break_by = 1
1503: ORDER BY 5, 2, 1 ASC;

Line 1524: FROM cst_mgd_mstr_book_temp CMIAKD

1520: ,CMIAKD.txn_qty TXN_QTY
1521: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1522: ,ROUND(CMIAKD.txn_h_total_cost, 2) TXN_VALUE
1523: ,CMIAKD.organization_id ORGANIZATION_ID
1524: FROM cst_mgd_mstr_book_temp CMIAKD
1525: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1526: AND p_break_by = 1
1527: AND p_detail = 'S'
1528: UNION ALL

Line 1544: FROM cst_mgd_mstr_book_temp CMIAKD

1540: ,CMIAKD.txn_qty TXN_QTY
1541: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1542: ,ROUND(CMIAKD.txn_h_total_cost, 2) TXN_VALUE
1543: ,CMIAKD.organization_id ORGANIZATION_ID
1544: FROM cst_mgd_mstr_book_temp CMIAKD
1545: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1546: AND CMIAKD.organization_id = p_organization_id
1547: AND p_break_by IN (2, 4)
1548: AND p_detail = 'S'

Line 1565: FROM cst_mgd_mstr_book_temp CMIAKD

1561: ,CMIAKD.txn_qty TXN_QTY
1562: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1563: ,ROUND(CMIAKD.txn_h_total_cost, 2) TXN_VALUE
1564: ,CMIAKD.organization_id ORGANIZATION_ID
1565: FROM cst_mgd_mstr_book_temp CMIAKD
1566: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1567: AND CMIAKD.organization_id = p_organization_id
1568: AND CMIAKD.subinventory_code = p_sub_inv_org_name
1569: AND CMIAKD.sub_inv_organization_id = p_sub_inv_org_id

Line 1579: FROM cst_mgd_mstr_book_temp

1575:
1576: CURSOR lcu_org
1577: IS
1578: SELECT DISTINCT organization_id
1579: FROM cst_mgd_mstr_book_temp
1580: WHERE inventory_item_id = p_inventory_item_id
1581: ORDER BY organization_id ASC;
1582:
1583: BEGIN

Line 1648: FROM cst_mgd_mstr_book_temp CMIAKD

1644: ,CMIAKD.txn_date TXN_DATE
1645: ,CMIAKD.txn_qty TXN_FNL_QTY
1646: ,ROUND(CMIAKD.txn_unit_cost, 2) * CMIAKD.txn_qty TXN_FNL_VALUE
1647: ,CMIAKD.organization_id ORGANIZATION_ID
1648: FROM cst_mgd_mstr_book_temp CMIAKD
1649: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1650: AND CMIAKD.organization_id = p_org_id
1651: AND p_break_by = 1
1652: ORDER BY 5, 2, 1 ASC;

Line 1661: FROM cst_mgd_mstr_book_temp CMIAKD

1657: ,CMIAKD.txn_date TXN_DATE
1658: ,CMIAKD.txn_fnl_qty TXN_FNL_QTY
1659: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1660: ,CMIAKD.organization_id ORGANIZATION_ID
1661: FROM cst_mgd_mstr_book_temp CMIAKD
1662: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1663: AND p_break_by = 1
1664: AND p_detail = 'S'
1665: UNION ALL

Line 1671: FROM cst_mgd_mstr_book_temp CMIAKD

1667: ,CMIAKD.txn_date TXN_DATE
1668: ,CMIAKD.txn_fnl_qty TXN_FNL_QTY
1669: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1670: ,CMIAKD.organization_id ORGANIZATION_ID
1671: FROM cst_mgd_mstr_book_temp CMIAKD
1672: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1673: AND CMIAKD.organization_id = p_organization_id
1674: AND p_break_by IN (2, 4)
1675: AND p_detail = 'S'

Line 1682: FROM cst_mgd_mstr_book_temp CMIAKD

1678: ,CMIAKD.txn_date TXN_DATE
1679: ,CMIAKD.txn_fnl_qty TXN_FNL_QTY
1680: ,ROUND(CMIAKD.txn_fnl_unit_cost, 2) * CMIAKD.txn_fnl_qty TXN_FNL_VALUE
1681: ,CMIAKD.organization_id ORGANIZATION_ID
1682: FROM cst_mgd_mstr_book_temp CMIAKD
1683: WHERE CMIAKD.inventory_item_id = p_inventory_item_id
1684: AND CMIAKD.organization_id = p_organization_id
1685: AND CMIAKD.subinventory_code = p_sub_inv_org_name
1686: AND CMIAKD.sub_inv_organization_id = p_sub_inv_org_id

Line 1696: FROM cst_mgd_mstr_book_temp

1692:
1693: CURSOR lcu_org
1694: IS
1695: SELECT DISTINCT organization_id
1696: FROM cst_mgd_mstr_book_temp
1697: WHERE inventory_item_id = p_inventory_item_id
1698: ORDER BY organization_id ASC;
1699:
1700: BEGIN

Line 1946: CST_MGD_MSTR_BOOK_TEMP;

1942: SELECT
1943: count(*)
1944: INTO COUNT_ROWS
1945: FROM
1946: CST_MGD_MSTR_BOOK_TEMP;
1947: RETURN (COUNT_ROWS);
1948: END CF_COUNT_ROWSFORMULA;
1949:
1950: FUNCTION P_DATE_FROMVALIDTRIGGER RETURN BOOLEAN IS

Line 2794: -- -- DELETE FROM CST_MGD_MSTR_BOOK_TEMP;

2790: -- --Parse the query
2791: -- DBMS_SQL.PARSE(v_cursorID, v_final_query, DBMS_SQL.V7);
2792: --
2793: -- -- Not needed as temporary table
2794: -- -- DELETE FROM CST_MGD_MSTR_BOOK_TEMP;
2795: --
2796: -- --bind the input variables
2797: -- DBMS_SQL.BIND_VARIABLE(v_cursorID,':org_id',p_org_id);
2798: -- DBMS_SQL.BIND_VARIABLE(v_cursorID,':to_date',l_rpt_to_date);