DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on CST_MGD_MSTR_BOOK_TEMP

Line 105: --| CST_MGD_MSTR_BOOK_TEMP |

101: --| Get_Acct_Period_Id_invmbk modified |
102: --| NOTE:Get_Acct_Period_id and Get_Acct_ |
103: --| Period_Id_invmbk are not used anywhere |
104: --| 02/17/2006 vmutyala Bug # 4086259 Added Creation_date to |
105: --| CST_MGD_MSTR_BOOK_TEMP |
106: --| 02/24/2006 vmutyala Bug # 4912772 Performance issue in the |
107: --| dynamic query in Create_Inv_Msbk_Rpt is|
108: --| resolved by restructuring the query |
109: --| 10/27/2008 vjavli FP Bug 7458643 fix:Standard cost update|

Line 191: CST_MGD_MSTR_BOOK_TEMP(

187: )
188: IS
189: BEGIN
190: INSERT INTO
191: CST_MGD_MSTR_BOOK_TEMP(
192: TRANSACTION_ID
193: , ORGANIZATION_ID
194: , INVENTORY_ITEM_ID
195: , UOM_CODE -- added for inv book

Line 1140: -- DELETE FROM CST_MGD_MSTR_BOOK_TEMP;

1136: --Parse the query
1137: DBMS_SQL.PARSE(v_cursorID, v_final_query, DBMS_SQL.V7);
1138:
1139: -- Not needed as temporary table
1140: -- DELETE FROM CST_MGD_MSTR_BOOK_TEMP;
1141:
1142: --bind the input variables
1143: DBMS_SQL.BIND_VARIABLE(v_cursorID,':org_id',p_org_id);
1144: DBMS_SQL.BIND_VARIABLE(v_cursorID,':to_date',l_rpt_to_date);