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.WMS_STRATEGY_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;

154: ) is
155:
156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;

Line 159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;

155:
156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;

Line 160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;

156: l_api_name VARCHAR2(30) := 'InitInput';
157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;

Line 161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;

157: l_pp_transaction_temp_id
158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;

Line 162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;

158: WMS_TRANSACTIONS_TEMP.PP_TRANSACTION_TEMP_ID%type;
159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;

Line 163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;

159: l_revision WMS_TRANSACTIONS_TEMP.REVISION%type;
160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;

Line 164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;

160: l_lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%type;
161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;

Line 165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;

161: l_lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%type;
162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;

Line 166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;

162: l_from_subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%type;
163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;

Line 167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;

163: l_from_locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%type;
164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

Line 168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;

164: l_from_cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%type;
165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;

Line 169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;

165: l_to_subinventory_code WMS_TRANSACTIONS_TEMP.TO_SUBINVENTORY_CODE%type;
166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;

Line 170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;

166: l_to_locator_id WMS_TRANSACTIONS_TEMP.TO_LOCATOR_ID%type;
167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;

Line 171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

167: l_to_cost_group_id WMS_TRANSACTIONS_TEMP.TO_COST_GROUP_ID%type;
168: l_primary_quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%type;
169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;

Line 173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;

169: l_secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%type;
170: l_grade_code WMS_TRANSACTIONS_TEMP.GRADE_CODE%type;
171: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
172: l_reservation_id NUMBER;
173: l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER%type;
174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;
176: l_to_organization_id NUMBER;
177:

Line 178: --- [ Added code - l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER; ]

174: l_transaction_action_id Number;
175: l_from_organization_id NUMBER;
176: l_to_organization_id NUMBER;
177:
178: --- [ Added code - l_serial_number WMS_TRANSACTIONS_TEMP.SERIAL_NUMBER; ]
179: l_lpn_id NUMBER;
180:
181: l_debug NUMBER;
182: --use to_organization if put away, from_organization if pick

Line 237: from WMS_TRANSACTIONS_TEMP mptt

233: ,mptt.grade_code
234: ,mptt.reservation_id
235: ,mptt.serial_number ---- [ Added code - ,mptt.serial_number ]
236: ,mptt.lpn_id
237: from WMS_TRANSACTIONS_TEMP mptt
238: where mptt.TRANSACTION_TEMP_ID = p_transaction_temp_id
239: and mptt.TYPE_CODE = p_type_code
240: and mptt.LINE_TYPE_CODE = 1
241: order by mptt.pp_transaction_temp_id

Line 1716: -- WMS_TRANSACTIONS_TEMP )

1712: -- at least one transaction detail record in
1713: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
1714: -- and parameters p_transaction_temp_id and p_type_code
1715: -- ( base tables MTL_MATERIAL_TRANSACTIONS_TEMP and
1716: -- WMS_TRANSACTIONS_TEMP )
1717: -- strategy record in WMS_STRATEGIES_B uniquely identified by
1718: -- parameter p_strategy_id
1719: -- at least one strategy member record in
1720: -- WMS_STRATEGY_MEMBERS identified by parameter

Line 1787: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;

1783: l_api_name constant varchar2(30) := 'Apply';
1784:
1785: l_organization_id MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID%type;
1786: l_inventory_item_id MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID%type;
1787: l_line_type_code WMS_TRANSACTIONS_TEMP.LINE_TYPE_CODE%type;
1788: l_transaction_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%type;
1789: l_primary_uom MTL_SYSTEM_ITEMS.PRIMARY_UOM_CODE%type;
1790: l_secondary_uom VARCHAR2(3) ; -- MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE%type;
1791: l_grade_code VARCHAR2(150);

Line 1856: FROM WMS_TRANSACTIONS_TEMP

1852: SELECT 'Y'
1853: FROM DUAL
1854: WHERE EXISTS(
1855: SELECT PP_TRANSACTION_TEMP_ID
1856: FROM WMS_TRANSACTIONS_TEMP
1857: WHERE TYPE_CODE = p_type_code
1858: AND LINE_TYPE_CODE = 2);
1859:
1860: begin