DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 17: -- mtl_material_transactions_temp.

13: -- API name : cartonize
14: -- Type : group
15: -- Function : populates the cartonization_id, container_item_id columns,
16: -- of rows belonging to a particular move order header id in
17: -- mtl_material_transactions_temp.
18:
19: -- Pre-reqs : Those columns won't be populated if the cartonization_id
20: -- for that row is already populated,
21: -- or if values for organization_id, inventory_item_id ,

Line 91: table_name VARCHAR2(200) := 'mtl_material_transactions_temp';

87: outbound VARCHAR2(1) := 'N';
88:
89: -- Sets the table on which we want to perform the operations insert,
90: -- delete, update etc
91: table_name VARCHAR2(200) := 'mtl_material_transactions_temp';
92:
93: TYPE attr_rec IS RECORD
94: ( inventory_item_id NUMBER
95: , gross_weight NUMBER

Line 111: SUBTYPE mmtt_row IS mtl_material_transactions_temp%ROWTYPE;

107:
108:
109:
110: --for device integration
111: SUBTYPE mmtt_row IS mtl_material_transactions_temp%ROWTYPE;
112: SUBTYPE wct_row_type IS wms_cartonization_temp%ROWTYPE;
113:
114: lpns_generated_tb inv_label.transaction_id_rec_type;
115:

Line 119: ( transaction_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE

115:
116:
117:
118: TYPE lpn_alloc_flag_rec IS RECORD
119: ( transaction_temp_id mtl_material_transactions_temp.transaction_temp_id%TYPE
120: , lpn_alloc_flag VARCHAR2(1)
121: );
122:
123: TYPE lpn_alloc_flag_tb IS TABLE OF lpn_alloc_flag_rec INDEX BY LONG;