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.

[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 23: -- WMS_TRANSACTIONS_TEMP, respectively );

19: -- At least one transaction detail record in
20: -- WMS_TRX_DETAILS_TMP_V identified by line type code = 1
21: -- and parameters p_transaction_temp_id and p_type_code
22: -- ( base tables are MTL_MATERIAL_TRANSACTIONS_TEMP and
23: -- WMS_TRANSACTIONS_TEMP, respectively );
24: -- Rule record has to exist in WMS_RULES_B uniquely
25: -- identified by parameter p_rule_id;
26: -- If picking, quantity tree has to exist, created through
27: -- INV_Quantity_Tree_PVT.Create_Tree and uniquely identified

Line 74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,

70: -- 10182554 Global variable to set if expired lots are allowed to be transacted
71:
72: g_allow_expired_lot_txn varchar2(1) := 'N';
73: TYPE t_pick_rec IS RECORD (
74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

Line 75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,

71:
72: g_allow_expired_lot_txn varchar2(1) := 'N';
73: TYPE t_pick_rec IS RECORD (
74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,

Line 76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,

72: g_allow_expired_lot_txn varchar2(1) := 'N';
73: TYPE t_pick_rec IS RECORD (
74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),

Line 77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,

73: TYPE t_pick_rec IS RECORD (
74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,

Line 78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

74: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,
82: serial_number VARCHAR2(30),

Line 79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,

75: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
76: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,
82: serial_number VARCHAR2(30),
83: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,

Line 81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,

77: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
78: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,
82: serial_number VARCHAR2(30),
83: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,
84: secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%TYPE,
85: grade_code VARCHAR2(150),

Line 83: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,

79: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,
82: serial_number VARCHAR2(30),
83: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,
84: secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%TYPE,
85: grade_code VARCHAR2(150),
86: consist_string VARCHAR2(1000),
87: order_by_string VARCHAR2(1000)

Line 84: secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%TYPE,

80: uom_code VARCHAR2(3),
81: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,
82: serial_number VARCHAR2(30),
83: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,
84: secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%TYPE,
85: grade_code VARCHAR2(150),
86: consist_string VARCHAR2(1000),
87: order_by_string VARCHAR2(1000)
88: );

Line 97: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,

93:
94: --- end of ref picking cursor ---
95:
96: TYPE t_put_rec IS RECORD (
97: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
98: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
99: project_id MTL_ITEM_LOCATIONS.PROJECT_ID%TYPE,
100: task_id MTL_ITEM_LOCATIONS.TASK_ID%TYPE
101: );

Line 98: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

94: --- end of ref picking cursor ---
95:
96: TYPE t_put_rec IS RECORD (
97: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
98: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
99: project_id MTL_ITEM_LOCATIONS.PROJECT_ID%TYPE,
100: task_id MTL_ITEM_LOCATIONS.TASK_ID%TYPE
101: );
102: