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.RCV_SHIPMENT_LINE_SV dependencies on RCV_TRANSACTIONS_INTERFACE

Line 25: po_line_id rcv_transactions_interface.po_line_id%type,

21: error_record rcv_shipment_object_sv.errorrectype);
22:
23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,

Line 26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

22:
23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

Line 27: to_organization_id rcv_transactions_interface.to_organization_id%type,

23: TYPE item_id_record_type IS RECORD
24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353

Line 28: item_description rcv_transactions_interface.item_description%type,

24: (item_id mtl_system_items_kfv.inventory_item_id%type,
25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,

Line 29: item_revision rcv_transactions_interface.item_revision%type,

25: po_line_id rcv_transactions_interface.po_line_id%type,
26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),

Line 30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

26: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),

Line 31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353

27: to_organization_id rcv_transactions_interface.to_organization_id%type,
28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),
35: error_record rcv_shipment_object_sv.ErrorRecType);

Line 32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,

28: item_description rcv_transactions_interface.item_description%type,
29: item_revision rcv_transactions_interface.item_revision%type,
30: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
31: use_mtl_lot rcv_transactions_interface.item_revision%type, -- bug 608353
32: use_mtl_serial rcv_transactions_interface.primary_unit_of_measure%type,
33: item_num varchar2(2000),
34: vendor_item_num varchar2(2000),
35: error_record rcv_shipment_object_sv.ErrorRecType);
36:

Line 47: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

43: (release_num po_releases.release_num%type,
44: po_release_id po_releases.po_release_id%type,
45: po_line_id po_lines.po_line_id%type,
46: shipment_num po_line_locations.shipment_num%type,
47: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
48: po_header_id rcv_transactions_interface.po_header_id%type,
49: error_record rcv_shipment_object_sv.ErrorRecType);
50:
51: TYPE po_line_id_record_type IS RECORD

Line 48: po_header_id rcv_transactions_interface.po_header_id%type,

44: po_release_id po_releases.po_release_id%type,
45: po_line_id po_lines.po_line_id%type,
46: shipment_num po_line_locations.shipment_num%type,
47: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
48: po_header_id rcv_transactions_interface.po_header_id%type,
49: error_record rcv_shipment_object_sv.ErrorRecType);
50:
51: TYPE po_line_id_record_type IS RECORD
52: (document_line_num po_lines.line_num%type,

Line 60: (po_header_id rcv_transactions_interface.po_header_id%type,

56: item_id mtl_system_items_kfv.inventory_item_id%type,
57: error_record rcv_shipment_object_sv.ErrorRecType);
58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);

Line 61: po_line_id rcv_transactions_interface.po_line_id%type,

57: error_record rcv_shipment_object_sv.ErrorRecType);
58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:

Line 62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

58:
59: TYPE po_line_location_id_rtype IS RECORD
60: (po_header_id rcv_transactions_interface.po_header_id%type,
61: po_line_id rcv_transactions_interface.po_line_id%type,
62: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD

Line 67: (intransit_owning_org_id rcv_transactions_interface.intransit_owning_org_id%type,

63: item_id mtl_system_items_kfv.inventory_item_id%type,
64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD
67: (intransit_owning_org_id rcv_transactions_interface.intransit_owning_org_id%type,
68: intransit_owning_org_code rcv_transactions_interface.intransit_owning_org_code%type,
69: error_record rcv_shipment_object_sv.ErrorRecType);
70:
71: TYPE sub_item_id_record_type IS RECORD

Line 68: intransit_owning_org_code rcv_transactions_interface.intransit_owning_org_code%type,

64: error_record rcv_shipment_object_sv.ErrorRecType);
65:
66: TYPE intransit_owning_org_rtype IS RECORD
67: (intransit_owning_org_id rcv_transactions_interface.intransit_owning_org_id%type,
68: intransit_owning_org_code rcv_transactions_interface.intransit_owning_org_code%type,
69: error_record rcv_shipment_object_sv.ErrorRecType);
70:
71: TYPE sub_item_id_record_type IS RECORD
72: (substitute_item_num varchar2(2000),

Line 75: po_line_id rcv_transactions_interface.po_line_id%type,

71: TYPE sub_item_id_record_type IS RECORD
72: (substitute_item_num varchar2(2000),
73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);

Line 76: to_organization_id rcv_transactions_interface.to_organization_id%type,

72: (substitute_item_num varchar2(2000),
73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);
80:

Line 77: vendor_id rcv_transactions_interface.vendor_id%type,

73: substitute_item_id mtl_system_items_kfv.inventory_item_id%type,
74: related_item_id mtl_related_items.related_item_id%type,
75: po_line_id rcv_transactions_interface.po_line_id%type,
76: to_organization_id rcv_transactions_interface.to_organization_id%type,
77: vendor_id rcv_transactions_interface.vendor_id%type,
78: vendor_item_num varchar2(2000),
79: error_record rcv_shipment_object_sv.ErrorRecType);
80:
81: TYPE po_lookup_code_record_type IS RECORD

Line 88: (item_category rcv_transactions_interface.item_category%type,

84: lookup_type po_lookup_codes.lookup_type%Type,
85: error_record rcv_shipment_object_sv.ErrorRecType);
86:
87: TYPE category_id_record_type IS RECORD
88: (item_category rcv_transactions_interface.item_category%type,
89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD

Line 89: category_id rcv_transactions_interface.category_id%type,

85: error_record rcv_shipment_object_sv.ErrorRecType);
86:
87: TYPE category_id_record_type IS RECORD
88: (item_category rcv_transactions_interface.item_category%type,
89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,

Line 93: (routing_code rcv_transactions_interface.routing_code%type,

89: category_id rcv_transactions_interface.category_id%type,
90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD

Line 94: routing_header_id rcv_transactions_interface.routing_header_id%type,

90: error_record rcv_shipment_object_sv.ErrorRecType);
91:
92: TYPE routing_header_id_rec_type IS RECORD
93: (routing_code rcv_transactions_interface.routing_code%type,
94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,

Line 98: (routing_step rcv_transactions_interface.routing_step%type,

94: routing_header_id rcv_transactions_interface.routing_header_id%type,
95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD

Line 99: routing_step_id rcv_transactions_interface.routing_step_id%type,

95: error_record rcv_shipment_object_sv.ErrorRecType);
96:
97: TYPE routing_step_id_rec_type IS RECORD
98: (routing_step rcv_transactions_interface.routing_step%type,
99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,

Line 103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,

99: routing_step_id rcv_transactions_interface.routing_step_id%type,
100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD

Line 104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,

100: error_record rcv_shipment_object_sv.ErrorRecType);
101:
102: TYPE deliver_to_person_id_rtype IS RECORD
103: (deliver_to_person_name rcv_transactions_interface.deliver_to_person_name%type,
104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,

Line 108: (full_name rcv_transactions_interface.deliver_to_person_name%type,

104: deliver_to_person_id rcv_transactions_interface.deliver_to_person_id%type,
105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,

Line 109: employee_id rcv_transactions_interface.deliver_to_location_id%type,

105: error_record rcv_shipment_object_sv.ErrorRecType);
106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);

Line 110: to_organization_id rcv_transactions_interface.to_organization_id%type,

106:
107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:

Line 111: destination_type_code rcv_transactions_interface.destination_type_code%type,

107: TYPE employee_record_type IS RECORD
108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD

Line 112: transaction_date rcv_transactions_interface.transaction_date%type,

108: (full_name rcv_transactions_interface.deliver_to_person_name%type,
109: employee_id rcv_transactions_interface.deliver_to_location_id%type,
110: to_organization_id rcv_transactions_interface.to_organization_id%type,
111: destination_type_code rcv_transactions_interface.destination_type_code%type,
112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,

Line 116: (location_code rcv_transactions_interface.deliver_to_location_code%type,

112: transaction_date rcv_transactions_interface.transaction_date%type,
113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,

Line 117: location_id rcv_transactions_interface.deliver_to_location_id%type,

113: error_record rcv_shipment_object_sv.ErrorRecType);
114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,

Line 118: to_organization_id rcv_transactions_interface.to_organization_id%type,

114:
115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);

Line 119: destination_type_code rcv_transactions_interface.destination_type_code%type,

115: TYPE location_record_type IS RECORD
116: (location_code rcv_transactions_interface.deliver_to_location_code%type,
117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:

Line 121: transaction_date rcv_transactions_interface.transaction_date%type,

117: location_id rcv_transactions_interface.deliver_to_location_id%type,
118: to_organization_id rcv_transactions_interface.to_organization_id%type,
119: destination_type_code rcv_transactions_interface.destination_type_code%type,
120: location_type_code po_lookup_codes.lookup_code%type,
121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,

Line 125: (subinventory rcv_transactions_interface.subinventory%type,

121: transaction_date rcv_transactions_interface.transaction_date%type,
122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,

Line 126: to_organization_id rcv_transactions_interface.to_organization_id%type,

122: error_record rcv_shipment_object_sv.ErrorRecType);
123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,

Line 127: destination_type_code rcv_transactions_interface.destination_type_code%type,

123:
124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,

Line 128: from_subinventory rcv_transactions_interface.subinventory%type,

124: TYPE subinventory_record_type IS RECORD
125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,

Line 129: from_organization_id rcv_transactions_interface.to_organization_id%type,

125: (subinventory rcv_transactions_interface.subinventory%type,
126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);

Line 130: source_document_code rcv_transactions_interface.source_document_code%type,

126: to_organization_id rcv_transactions_interface.to_organization_id%type,
127: destination_type_code rcv_transactions_interface.destination_type_code%type,
128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);
134:

Line 132: transaction_date rcv_transactions_interface.transaction_date%type,

128: from_subinventory rcv_transactions_interface.subinventory%type,
129: from_organization_id rcv_transactions_interface.to_organization_id%type,
130: source_document_code rcv_transactions_interface.source_document_code%type,
131: item_id mtl_system_items_kfv.inventory_item_id%type,
132: transaction_date rcv_transactions_interface.transaction_date%type,
133: error_record rcv_shipment_object_sv.ErrorRecType);
134:
135: /*
136: ** Bug 724495

Line 143: (locator rcv_transactions_interface.locator%type,

139: */
140:
141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,

Line 144: locator_id rcv_transactions_interface.locator_id%type,

140:
141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,

Line 145: subinventory rcv_transactions_interface.subinventory%type,

141:
142: TYPE locator_record_type IS RECORD
143: (locator rcv_transactions_interface.locator%type,
144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,

Line 148: to_organization_id rcv_transactions_interface.to_organization_id%type,

144: locator_id rcv_transactions_interface.locator_id%type,
145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,

Line 149: destination_type_code rcv_transactions_interface.destination_type_code%type,

145: subinventory rcv_transactions_interface.subinventory%type,
146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,

Line 150: from_subinventory rcv_transactions_interface.subinventory%type,

146: subinventory_locator_control mtl_system_items.location_control_code%type,
147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,

Line 151: from_organization_id rcv_transactions_interface.to_organization_id%type,

147: restrict_locator_control mtl_system_items.restrict_locators_code%type,
148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: error_record rcv_shipment_object_sv.ErrorRecType);

Line 152: source_document_code rcv_transactions_interface.source_document_code%type,

148: to_organization_id rcv_transactions_interface.to_organization_id%type,
149: destination_type_code rcv_transactions_interface.destination_type_code%type,
150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: error_record rcv_shipment_object_sv.ErrorRecType);
156:

Line 154: transaction_date rcv_transactions_interface.transaction_date%type,

150: from_subinventory rcv_transactions_interface.subinventory%type,
151: from_organization_id rcv_transactions_interface.to_organization_id%type,
152: source_document_code rcv_transactions_interface.source_document_code%type,
153: item_id mtl_system_items_kfv.inventory_item_id%type,
154: transaction_date rcv_transactions_interface.transaction_date%type,
155: error_record rcv_shipment_object_sv.ErrorRecType);
156:
157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,

Line 158: (locator rcv_transactions_interface.locator%type,

154: transaction_date rcv_transactions_interface.transaction_date%type,
155: error_record rcv_shipment_object_sv.ErrorRecType);
156:
157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
160: subinventory rcv_transactions_interface.subinventory%type,
161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);

Line 159: locator_id rcv_transactions_interface.locator_id%type,

155: error_record rcv_shipment_object_sv.ErrorRecType);
156:
157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
160: subinventory rcv_transactions_interface.subinventory%type,
161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);
163:

Line 160: subinventory rcv_transactions_interface.subinventory%type,

156:
157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
160: subinventory rcv_transactions_interface.subinventory%type,
161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);
163:
164: TYPE location_id_record_type IS RECORD

Line 161: to_organization_id rcv_transactions_interface.to_organization_id%type,

157: TYPE locator_id_record_type IS RECORD
158: (locator rcv_transactions_interface.locator%type,
159: locator_id rcv_transactions_interface.locator_id%type,
160: subinventory rcv_transactions_interface.subinventory%type,
161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);
163:
164: TYPE location_id_record_type IS RECORD
165: (location_code rcv_transactions_interface.location_code%type,

Line 165: (location_code rcv_transactions_interface.location_code%type,

161: to_organization_id rcv_transactions_interface.to_organization_id%type,
162: error_record rcv_shipment_object_sv.ErrorRecType);
163:
164: TYPE location_id_record_type IS RECORD
165: (location_code rcv_transactions_interface.location_code%type,
166: location_id rcv_transactions_interface.location_id%type,
167: error_record rcv_shipment_object_sv.ErrorRecType);
168:
169: TYPE reason_id_record_type IS RECORD

Line 166: location_id rcv_transactions_interface.location_id%type,

162: error_record rcv_shipment_object_sv.ErrorRecType);
163:
164: TYPE location_id_record_type IS RECORD
165: (location_code rcv_transactions_interface.location_code%type,
166: location_id rcv_transactions_interface.location_id%type,
167: error_record rcv_shipment_object_sv.ErrorRecType);
168:
169: TYPE reason_id_record_type IS RECORD
170: (reason_name rcv_transactions_interface.reason_name%type,

Line 170: (reason_name rcv_transactions_interface.reason_name%type,

166: location_id rcv_transactions_interface.location_id%type,
167: error_record rcv_shipment_object_sv.ErrorRecType);
168:
169: TYPE reason_id_record_type IS RECORD
170: (reason_name rcv_transactions_interface.reason_name%type,
171: reason_id rcv_transactions_interface.reason_id%type,
172: error_record rcv_shipment_object_sv.ErrorRecType);
173:
174: TYPE quantity_shipped_record_type IS RECORD

Line 171: reason_id rcv_transactions_interface.reason_id%type,

167: error_record rcv_shipment_object_sv.ErrorRecType);
168:
169: TYPE reason_id_record_type IS RECORD
170: (reason_name rcv_transactions_interface.reason_name%type,
171: reason_id rcv_transactions_interface.reason_id%type,
172: error_record rcv_shipment_object_sv.ErrorRecType);
173:
174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,

Line 175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,

171: reason_id rcv_transactions_interface.reason_id%type,
172: error_record rcv_shipment_object_sv.ErrorRecType);
173:
174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

Line 176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,

172: error_record rcv_shipment_object_sv.ErrorRecType);
173:
174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,

Line 177: item_id rcv_transactions_interface.item_id%type,

173:
174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,

Line 178: po_line_id rcv_transactions_interface.po_line_id%type,

174: TYPE quantity_shipped_record_type IS RECORD
175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,

Line 179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

175: (quantity_shipped rcv_transactions_interface.quantity_shipped%type,
176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,

Line 180: to_organization_id rcv_transactions_interface.to_organization_id%type,

176: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

Line 181: po_header_id rcv_transactions_interface.po_header_id%type,

177: item_id rcv_transactions_interface.item_id%type,
178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);

Line 182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,

178: po_line_id rcv_transactions_interface.po_line_id%type,
179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);
186:

Line 183: primary_quantity rcv_transactions_interface.primary_quantity%type,

179: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);
186:
187: TYPE expected_receipt_record_type IS RECORD

Line 184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

180: to_organization_id rcv_transactions_interface.to_organization_id%type,
181: po_header_id rcv_transactions_interface.po_header_id%type,
182: interface_transaction_id rcv_transactions_interface.interface_transaction_id%type,
183: primary_quantity rcv_transactions_interface.primary_quantity%type,
184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);
186:
187: TYPE expected_receipt_record_type IS RECORD
188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,

Line 188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,

184: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
185: error_record rcv_shipment_object_sv.ErrorRecType);
186:
187: TYPE expected_receipt_record_type IS RECORD
188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
189: line_location_id rcv_transactions_interface.po_line_location_id%type,
190: error_record rcv_shipment_object_sv.ErrorRecType);
191:
192: TYPE quantity_invoiced_record_type IS RECORD

Line 189: line_location_id rcv_transactions_interface.po_line_location_id%type,

185: error_record rcv_shipment_object_sv.ErrorRecType);
186:
187: TYPE expected_receipt_record_type IS RECORD
188: (expected_receipt_date rcv_transactions_interface.expected_receipt_date%type,
189: line_location_id rcv_transactions_interface.po_line_location_id%type,
190: error_record rcv_shipment_object_sv.ErrorRecType);
191:
192: TYPE quantity_invoiced_record_type IS RECORD
193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,

Line 193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,

189: line_location_id rcv_transactions_interface.po_line_location_id%type,
190: error_record rcv_shipment_object_sv.ErrorRecType);
191:
192: TYPE quantity_invoiced_record_type IS RECORD
193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,

Line 197: (to_organization_id rcv_transactions_interface.to_organization_id%type,

193: (quantity_invoiced rcv_transactions_interface.quantity_invoiced%type,
194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,

Line 198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,

194: error_record rcv_shipment_object_sv.ErrorRecType);
195:
196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,

Line 199: po_header_id rcv_transactions_interface.po_header_id%type,

195:
196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,

Line 200: po_line_id rcv_transactions_interface.po_line_id%type,

196: TYPE ref_integrity_record_type IS RECORD
197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,

Line 201: vendor_id rcv_transactions_interface.vendor_id%type,

197: (to_organization_id rcv_transactions_interface.to_organization_id%type,
198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,

Line 202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,

198: po_line_location_id rcv_transactions_interface.po_line_location_id%type,
199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,
206: error_record rcv_shipment_object_sv.ErrorRecType,

Line 203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,

199: po_header_id rcv_transactions_interface.po_header_id%type,
200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,
206: error_record rcv_shipment_object_sv.ErrorRecType,
207: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);

Line 204: po_revision_num rcv_transactions_interface.po_revision_num%type,

200: po_line_id rcv_transactions_interface.po_line_id%type,
201: vendor_id rcv_transactions_interface.vendor_id%type,
202: vendor_item_num rcv_transactions_interface.vendor_item_num%type,
203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,
206: error_record rcv_shipment_object_sv.ErrorRecType,
207: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
208: /*

Line 207: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);

203: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
204: po_revision_num rcv_transactions_interface.po_revision_num%type,
205: item_id mtl_system_items_kfv.inventory_item_id%type,
206: error_record rcv_shipment_object_sv.ErrorRecType,
207: parent_txn_id rcv_transactions_interface.parent_transaction_id%TYPE);
208: /*
209: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
210: */
211:

Line 213: (to_organization_id rcv_transactions_interface.to_organization_id%type,

209: Added the 'parent_txn_id' column to above rec so as to handle bug 6447564 issue.
210: */
211:
212: TYPE freight_carrier_record_type IS RECORD
213: (to_organization_id rcv_transactions_interface.to_organization_id%type,
214: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,
215: po_header_id po_headers.po_header_id%type,
216: error_record rcv_shipment_object_sv.ErrorRecType);
217:

Line 214: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,

210: */
211:
212: TYPE freight_carrier_record_type IS RECORD
213: (to_organization_id rcv_transactions_interface.to_organization_id%type,
214: freight_carrier_code rcv_transactions_interface.freight_carrier_code%type,
215: po_header_id po_headers.po_header_id%type,
216: error_record rcv_shipment_object_sv.ErrorRecType);
217:
218: TYPE tax_name_record_type IS RECORD

Line 219: (tax_name rcv_transactions_interface.tax_name%type,

215: po_header_id po_headers.po_header_id%type,
216: error_record rcv_shipment_object_sv.ErrorRecType);
217:
218: TYPE tax_name_record_type IS RECORD
219: (tax_name rcv_transactions_interface.tax_name%type,
220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
222: --FRKHAN 12/18/98 add new record type for country of origin
223: TYPE country_of_origin_record_type IS RECORD

Line 224: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,

220: error_record rcv_shipment_object_sv.ErrorRecType);
221:
222: --FRKHAN 12/18/98 add new record type for country of origin
223: TYPE country_of_origin_record_type IS RECORD
224: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
225: error_record rcv_shipment_object_sv.ErrorRecType);
226:
227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,

Line 228: (to_organization_id rcv_transactions_interface.to_organization_id%type,

224: (country_of_origin_code rcv_transactions_interface.country_of_origin_code%type,
225: error_record rcv_shipment_object_sv.ErrorRecType);
226:
227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,

Line 229: po_header_id rcv_transactions_interface.po_header_id%type,

225: error_record rcv_shipment_object_sv.ErrorRecType);
226:
227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,

Line 230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,

226:
227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,

Line 231: transaction_date rcv_transactions_interface.transaction_date%type,

227: TYPE cum_quantity_record_type IS RECORD
228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,

Line 232: vendor_id rcv_transactions_interface.vendor_id%type,

228: (to_organization_id rcv_transactions_interface.to_organization_id%type,
229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,

Line 233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,

229: po_header_id rcv_transactions_interface.po_header_id%type,
230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

Line 234: item_id rcv_transactions_interface.item_id%type,

230: vendor_cum_shipped_qty rcv_transactions_interface.vendor_cum_shipped_qty%type,
231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
238: error_record rcv_shipment_object_sv.ErrorRecType);

Line 235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,

231: transaction_date rcv_transactions_interface.transaction_date%type,
232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
238: error_record rcv_shipment_object_sv.ErrorRecType);
239:

Line 236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,

232: vendor_id rcv_transactions_interface.vendor_id%type,
233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
238: error_record rcv_shipment_object_sv.ErrorRecType);
239:
240: /*===========================================================================

Line 237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,

233: vendor_site_id rcv_transactions_interface.vendor_site_id%type,
234: item_id rcv_transactions_interface.item_id%type,
235: quantity_shipped rcv_transactions_interface.quantity_shipped%type,
236: unit_of_measure rcv_transactions_interface.unit_of_measure%type,
237: primary_unit_of_measure rcv_transactions_interface.primary_unit_of_measure%type,
238: error_record rcv_shipment_object_sv.ErrorRecType);
239:
240: /*===========================================================================
241: PROCEDURE NAME: create_shipment_line()