APPS.WMS_STRATEGY_PVT dependencies on WMS_STRATEGY_MAT_TXN_TMP_V

Line 200: ,wms_strategy_mat_txn_tmp_v mpsmttv

196: ,mpsmttv.transaction_uom
197: ,msi.primary_uom_code
198: ,msi.secondary_uom_code
199: from mtl_system_items msi
200: ,wms_strategy_mat_txn_tmp_v mpsmttv
201: where msi.organization_id =
202: decode(p_type_code, 1, mpsmttv.to_organization_id,
203: mpsmttv.from_organization_id)
204: and msi.inventory_item_id = mpsmttv.inventory_item_id

Line 362: 'WMS_STRATEGY_MAT_TXN_TMP_V could not be found. ' ||

358: -- raise no_data_found;
359: If (l_debug = 1) then
360: log_event(l_api_name, 'no_input_head',
361: 'The general input information stored in ' ||
362: 'WMS_STRATEGY_MAT_TXN_TMP_V could not be found. ' ||
363: 'Detailing will fail.');
364: End if;
365: end if;
366: close inphead;

Line 893: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely

889: -- assignments to business objects.
890: -- Calls stub procedure to search for strategy assignments in a
891: -- customer-defined manner before actually following his own
892: -- algorithm to determine the valid strategy.
893: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
894: -- identified by parameters p_transaction_temp_id and
895: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
896: -- Parameters :
897: -- p_api_version in number required

Line 984: from WMS_STRATEGY_MAT_TXN_TMP_V mpsmttv

980: -- cursor for getting actual inventory org to search for strategy
981: cursor input is
982: select decode(p_type_code, 1, mpsmttv.TO_ORGANIZATION_ID,
983: mpsmttv.FROM_ORGANIZATION_ID) organization_id
984: from WMS_STRATEGY_MAT_TXN_TMP_V mpsmttv
985: where mpsmttv.LINE_ID = p_transaction_temp_id
986: and mpsmttv.TYPE_CODE = p_type_code;
987:
988: --cursor for getting org for cost group search

Line 1864: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely

1860: -- API name : Apply
1861: -- Type : Private
1862: -- Function : Applies a pick or put away strategy to the given transaction
1863: -- or reservation input parameters and creates recommendations
1864: -- Pre-reqs : transaction record in WMS_STRATEGY_MAT_TXN_TMP_V uniquely
1865: -- identified by parameters p_transaction_temp_id and
1866: -- p_type_code ( base table MTL_MATERIAL_TRANSACTIONS_TEMP )
1867: -- at least one transaction detail record in
1868: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1