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_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 71: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,

67:
68: -- Creating ref cursor to call picking rules
69:
70: TYPE t_pick_rec IS RECORD (
71: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
72: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
73: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
74: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
75: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

Line 72: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,

68: -- Creating ref cursor to call picking rules
69:
70: TYPE t_pick_rec IS RECORD (
71: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
72: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
73: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
74: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
75: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
76: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,

Line 73: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,

69:
70: TYPE t_pick_rec IS RECORD (
71: revision WMS_TRANSACTIONS_TEMP.REVISION%TYPE,
72: lot_number WMS_TRANSACTIONS_TEMP.LOT_NUMBER%TYPE,
73: lot_expiration_date WMS_TRANSACTIONS_TEMP.LOT_EXPIRATION_DATE%TYPE,
74: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,
75: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,
76: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,
77: uom_code VARCHAR2(3),

Line 74: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,

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

Line 75: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

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

Line 76: cost_group_id WMS_TRANSACTIONS_TEMP.FROM_COST_GROUP_ID%TYPE,

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

Line 78: lpn_id WMS_TRANSACTIONS_TEMP.LPN_ID%TYPE,

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

Line 80: quantity WMS_TRANSACTIONS_TEMP.PRIMARY_QUANTITY%TYPE,

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

Line 81: secondary_quantity WMS_TRANSACTIONS_TEMP.SECONDARY_QUANTITY%TYPE,

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

Line 94: subinventory_code WMS_TRANSACTIONS_TEMP.FROM_SUBINVENTORY_CODE%TYPE,

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

Line 95: locator_id WMS_TRANSACTIONS_TEMP.FROM_LOCATOR_ID%TYPE,

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