APPS.PO_CREATE_REQUISITION_SV dependencies on PO_REQUISITION_LINES_ALL

Line 60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE

56: ,emergency_po_num po_requisition_headers_all.emergency_po_num%TYPE
57: );
58:
59: TYPE Line_Rec_type IS RECORD
60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE
61: ,requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
62: ,line_num po_requisition_lines_all.line_num%TYPE
63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE

Line 62: ,line_num po_requisition_lines_all.line_num%TYPE

58:
59: TYPE Line_Rec_type IS RECORD
60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE
61: ,requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
62: ,line_num po_requisition_lines_all.line_num%TYPE
63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE

Line 63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE

59: TYPE Line_Rec_type IS RECORD
60: (requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE
61: ,requisition_header_id po_requisition_headers_all.requisition_header_id%TYPE
62: ,line_num po_requisition_lines_all.line_num%TYPE
63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE

Line 66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE

62: ,line_num po_requisition_lines_all.line_num%TYPE
63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE

Line 67: ,unit_price po_requisition_lines_all.unit_price%TYPE

63: ,line_type_id po_requisition_lines_all.line_type_id%TYPE
64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE

Line 68: ,quantity po_requisition_lines_all.quantity%TYPE

64: ,category_id mtl_categories.category_id%TYPE
65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE

Line 69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE

65: ,item_description mtl_system_items.description%TYPE
66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE

Line 70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE

66: ,unit_meas_lookup_code po_requisition_lines_all.unit_meas_lookup_code%TYPE
67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE

Line 71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE

67: ,unit_price po_requisition_lines_all.unit_price%TYPE
68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE

Line 72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE

68: ,quantity po_requisition_lines_all.quantity%TYPE
69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE

Line 73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE

69: ,deliver_to_location_id po_requisition_lines_all.deliver_to_location_id%TYPE
70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE

Line 74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE

70: ,to_person_id po_requisition_lines_all.to_person_id%TYPE
71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE

Line 75: ,creation_date po_requisition_lines_all.creation_date%TYPE

71: ,last_update_date po_requisition_lines_all.last_update_date%TYPE
72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE

Line 76: ,created_by po_requisition_lines_all.created_by%TYPE

72: ,last_updated_by po_requisition_lines_all.last_updated_by%TYPE
73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE

Line 77: ,item_id po_requisition_lines_all.item_id%TYPE

73: ,source_type_code po_requisition_lines_all.source_type_code%TYPE
74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE

Line 78: ,item_revision po_requisition_lines_all.item_revision%TYPE

74: ,last_update_login po_requisition_lines_all.last_update_login%TYPE
75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE

Line 79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE

75: ,creation_date po_requisition_lines_all.creation_date%TYPE
76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE

Line 80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE

76: ,created_by po_requisition_lines_all.created_by%TYPE
77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE

Line 81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE

77: ,item_id po_requisition_lines_all.item_id%TYPE
78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE

Line 82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE

78: ,item_revision po_requisition_lines_all.item_revision%TYPE
79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE

Line 83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE

79: ,quantity_delivered po_requisition_lines_all.quantity_delivered%TYPE
80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE

Line 84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE

80: ,suggested_buyer_id po_requisition_lines_all.suggested_buyer_id%TYPE
81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE

Line 85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE

81: ,encumbered_flag po_requisition_lines_all.encumbered_flag%TYPE
82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE

Line 86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE

82: ,rfq_required_flag po_requisition_lines_all.rfq_required_flag%TYPE
83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE

Line 87: ,justification po_requisition_lines_all.justification%TYPE

83: ,need_by_date po_requisition_lines_all.need_by_date%TYPE
84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE

Line 88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE

84: ,line_location_id po_requisition_lines_all.line_location_id%TYPE
85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE

Line 89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE

85: ,modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%TYPE
86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE

Line 90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE

86: ,parent_req_line_id po_requisition_lines_all.parent_req_line_id%TYPE
87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE

Line 91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE

87: ,justification po_requisition_lines_all.justification%TYPE
88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE

Line 92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE

88: ,note_to_agent po_requisition_lines_all.note_to_agent%TYPE
89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE

Line 93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE

89: ,note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE
90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE

Line 94: ,currency_code po_requisition_lines_all.currency_code%TYPE

90: ,purchasing_agent_id po_requisition_lines_all.purchasing_agent_id%TYPE
91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE

Line 95: ,rate_type po_requisition_lines_all.rate_type%TYPE

91: ,document_type_code po_requisition_lines_all.document_type_code%TYPE
92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE

Line 96: ,rate_date po_requisition_lines_all.rate_date%TYPE

92: ,blanket_po_header_id po_requisition_lines_all.blanket_po_header_id%TYPE
93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE

Line 97: ,rate po_requisition_lines_all.rate%TYPE

93: ,blanket_po_line_num po_requisition_lines_all.blanket_po_line_num%TYPE
94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE

Line 98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE

94: ,currency_code po_requisition_lines_all.currency_code%TYPE
95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE

Line 99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE

95: ,rate_type po_requisition_lines_all.rate_type%TYPE
96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE

Line 100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE

96: ,rate_date po_requisition_lines_all.rate_date%TYPE
97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE

Line 101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE

97: ,rate po_requisition_lines_all.rate%TYPE
98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE

Line 102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE

98: ,currency_unit_price po_requisition_lines_all.currency_unit_price%TYPE
99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE

Line 103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE

99: ,suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%TYPE
100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE

Line 104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE

100: ,suggested_vendor_location po_requisition_lines_all.suggested_vendor_location%TYPE
101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE

Line 105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE

101: ,suggested_vendor_contact po_requisition_lines_all.suggested_vendor_contact%TYPE
102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE

Line 106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE

102: ,suggested_vendor_phone po_requisition_lines_all.suggested_vendor_phone%TYPE
103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE

Line 107: ,reference_num po_requisition_lines_all.reference_num%TYPE

103: ,suggested_vendor_product_code po_requisition_lines_all.suggested_vendor_product_code%TYPE
104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE

Line 108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE

104: ,un_number_id po_requisition_lines_all.un_number_id%TYPE
105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE

Line 109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE

105: ,hazard_class_id po_requisition_lines_all.hazard_class_id%TYPE
106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE

Line 110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE

106: ,must_use_sugg_vendor_flag po_requisition_lines_all.must_use_sugg_vendor_flag%TYPE
107: ,reference_num po_requisition_lines_all.reference_num%TYPE
108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE

Line 112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE

108: ,on_rfq_flag po_requisition_lines_all.on_rfq_flag%TYPE
109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE

Line 113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE

109: ,urgent_flag po_requisition_lines_all.urgent_flag%TYPE
110: ,cancel_flag po_requisition_lines_all.cancel_flag%TYPE
111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE

Line 115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE

111: ,source_organization_id org_organization_definitions.organization_id%TYPE
112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE

Line 116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE

112: ,source_subinventory po_requisition_lines_all.source_subinventory%TYPE
113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE

Line 117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE

113: ,destination_type_code po_requisition_lines_all.destination_type_code%TYPE
114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE

Line 118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE

114: ,destination_organization_id org_organization_definitions.organization_id%TYPE
115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE

Line 119: ,closed_code po_requisition_lines_all.closed_code%TYPE

115: ,destination_subinventory po_requisition_lines_all.destination_subinventory%TYPE
116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE

Line 120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE

116: ,quantity_cancelled po_requisition_lines_all.quantity_cancelled%TYPE
117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE

Line 121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE

117: ,cancel_date po_requisition_lines_all.cancel_date%TYPE
118: ,cancel_reason po_requisition_lines_all.cancel_reason%TYPE
119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE

Line 123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE

119: ,closed_code po_requisition_lines_all.closed_code%TYPE
120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE

Line 124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE

120: ,agent_return_note po_requisition_lines_all.agent_return_note%TYPE
121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE

Line 125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE

121: ,changed_after_research_flag po_requisition_lines_all.changed_after_research_flag%TYPE
122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE

Line 126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE

122: ,vendor_id po_vendors.vendor_id%TYPE
123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE

Line 127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE

123: ,vendor_site_id po_requisition_lines_all.vendor_site_id%TYPE
124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE

Line 128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE

124: ,vendor_contact_id po_requisition_lines_all.vendor_contact_id%TYPE
125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE

Line 129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE

125: ,research_agent_id po_requisition_lines_all.research_agent_id%TYPE
126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE

Line 130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE

126: ,wip_entity_id po_requisition_lines_all.wip_entity_id%TYPE
127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE

Line 131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE

127: ,wip_line_id po_requisition_lines_all.wip_line_id%TYPE
128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE

Line 132: ,destination_context po_requisition_lines_all.destination_context%TYPE

128: ,wip_repetitive_schedule_id po_requisition_lines_all.wip_repetitive_schedule_id%TYPE
129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE

Line 133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE

129: ,wip_operation_seq_num po_requisition_lines_all.wip_operation_seq_num%TYPE
130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE

Line 134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE

130: ,wip_resource_seq_num po_requisition_lines_all.wip_resource_seq_num%TYPE
131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE

Line 135: ,attribute1 po_requisition_lines_all.attribute1%TYPE

131: ,attribute_category po_requisition_lines_all.attribute_category%TYPE
132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE

Line 136: ,attribute2 po_requisition_lines_all.attribute2%TYPE

132: ,destination_context po_requisition_lines_all.destination_context%TYPE
133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE

Line 137: ,attribute3 po_requisition_lines_all.attribute3%TYPE

133: ,inventory_source_context po_requisition_lines_all.inventory_source_context%TYPE
134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE

Line 138: ,attribute4 po_requisition_lines_all.attribute4%TYPE

134: ,vendor_source_context po_requisition_lines_all.vendor_source_context%TYPE
135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE

Line 139: ,attribute5 po_requisition_lines_all.attribute5%TYPE

135: ,attribute1 po_requisition_lines_all.attribute1%TYPE
136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE

Line 140: ,attribute6 po_requisition_lines_all.attribute6%TYPE

136: ,attribute2 po_requisition_lines_all.attribute2%TYPE
137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE

Line 141: ,attribute7 po_requisition_lines_all.attribute7%TYPE

137: ,attribute3 po_requisition_lines_all.attribute3%TYPE
138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE

Line 142: ,attribute8 po_requisition_lines_all.attribute8%TYPE

138: ,attribute4 po_requisition_lines_all.attribute4%TYPE
139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE

Line 143: ,attribute9 po_requisition_lines_all.attribute9%TYPE

139: ,attribute5 po_requisition_lines_all.attribute5%TYPE
140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE

Line 144: ,attribute10 po_requisition_lines_all.attribute10%TYPE

140: ,attribute6 po_requisition_lines_all.attribute6%TYPE
141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE

Line 145: ,attribute11 po_requisition_lines_all.attribute11%TYPE

141: ,attribute7 po_requisition_lines_all.attribute7%TYPE
142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE

Line 146: ,attribute12 po_requisition_lines_all.attribute12%TYPE

142: ,attribute8 po_requisition_lines_all.attribute8%TYPE
143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE

Line 147: ,attribute13 po_requisition_lines_all.attribute13%TYPE

143: ,attribute9 po_requisition_lines_all.attribute9%TYPE
144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE

Line 148: ,attribute14 po_requisition_lines_all.attribute14%TYPE

144: ,attribute10 po_requisition_lines_all.attribute10%TYPE
145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE

Line 149: ,attribute15 po_requisition_lines_all.attribute15%TYPE

145: ,attribute11 po_requisition_lines_all.attribute11%TYPE
146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE

Line 150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE

146: ,attribute12 po_requisition_lines_all.attribute12%TYPE
147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE

Line 151: ,government_context po_requisition_lines_all.government_context%TYPE

147: ,attribute13 po_requisition_lines_all.attribute13%TYPE
148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE

Line 152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE

148: ,attribute14 po_requisition_lines_all.attribute14%TYPE
149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE

Line 153: ,closed_date po_requisition_lines_all.closed_date%TYPE

149: ,attribute15 po_requisition_lines_all.attribute15%TYPE
150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE

Line 154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE

150: ,bom_resource_id po_requisition_lines_all.bom_resource_id%TYPE
151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE

Line 155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE

151: ,government_context po_requisition_lines_all.government_context%TYPE
152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE

Line 156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE

152: ,closed_reason po_requisition_lines_all.closed_reason%TYPE
153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE

Line 157: ,org_id po_requisition_lines_all.org_id%TYPE

153: ,closed_date po_requisition_lines_all.closed_date%TYPE
154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE

Line 158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE

154: ,transaction_reason_code po_requisition_lines_all.transaction_reason_code%TYPE
155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE

Line 159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE

155: ,quantity_received po_requisition_lines_all.quantity_received%TYPE
156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE

Line 160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE

156: ,source_req_line_id po_requisition_lines_all.source_req_line_id%TYPE
157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE

Line 161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE

157: ,org_id po_requisition_lines_all.org_id%TYPE
158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE

Line 162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE

158: ,kanban_card_id po_requisition_lines_all.kanban_card_id%TYPE
159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE

Line 163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE

159: ,catalog_type po_requisition_lines_all.catalog_type%TYPE
160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE

Line 164: ,requester_email po_requisition_lines_all.requester_email%TYPE

160: ,catalog_source po_requisition_lines_all.catalog_source%TYPE
161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE

Line 165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE

161: ,manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE
162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE

Line 166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE

162: ,manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE
163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE

Line 167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE

163: ,manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE
164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE

Line 168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE

164: ,requester_email po_requisition_lines_all.requester_email%TYPE
165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE

Line 169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE

165: ,requester_fax po_requisition_lines_all.requester_fax%TYPE
166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE

Line 170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE

166: ,requester_phone po_requisition_lines_all.requester_phone%TYPE
167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE

Line 171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE

167: ,unspsc_code po_requisition_lines_all.unspsc_code%TYPE
168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE

Line 172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE

168: ,other_category_code po_requisition_lines_all.other_category_code%TYPE
169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE

Line 173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE

169: ,supplier_duns po_requisition_lines_all.supplier_duns%TYPE
170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE

Line 174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE

170: ,tax_status_indicator po_requisition_lines_all.tax_status_indicator%TYPE
171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE

Line 175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE

171: ,pcard_flag po_requisition_lines_all.pcard_flag%TYPE
172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE

Line 176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE

172: ,new_supplier_flag po_requisition_lines_all.new_supplier_flag%TYPE
173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE

Line 177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE

173: ,auto_receive_flag po_requisition_lines_all.auto_receive_flag%TYPE
174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number

Line 178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE

174: ,tax_user_override_flag po_requisition_lines_all.tax_user_override_flag%TYPE
175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)

Line 179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE

175: ,tax_code_id po_requisition_lines_all.tax_code_id%TYPE
176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)
183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE

Line 180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE

176: ,note_to_vendor po_requisition_lines_all.note_to_vendor%TYPE
177: ,oke_contract_version_id po_requisition_lines_all.oke_contract_version_id%TYPE
178: ,oke_contract_header_id po_requisition_lines_all.oke_contract_header_id%TYPE
179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)
183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE
184: ,purchase_basis po_requisition_lines_all.purchase_basis%TYPE

Line 183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE

179: ,item_source_id po_requisition_lines_all.item_source_id%TYPE
180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)
183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE
184: ,purchase_basis po_requisition_lines_all.purchase_basis%TYPE
185: ,matching_basis po_requisition_lines_all.matching_basis%TYPE
186: );
187:

Line 184: ,purchase_basis po_requisition_lines_all.purchase_basis%TYPE

180: ,supplier_ref_number po_requisition_lines_all.supplier_ref_number%TYPE
181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)
183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE
184: ,purchase_basis po_requisition_lines_all.purchase_basis%TYPE
185: ,matching_basis po_requisition_lines_all.matching_basis%TYPE
186: );
187:
188: TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type

Line 185: ,matching_basis po_requisition_lines_all.matching_basis%TYPE

181: ,source_doc_line_reference number
182: ,uom_code VARCHAR2(3)
183: ,order_type_lookup_code po_requisition_lines_all.order_type_lookup_code%TYPE
184: ,purchase_basis po_requisition_lines_all.purchase_basis%TYPE
185: ,matching_basis po_requisition_lines_all.matching_basis%TYPE
186: );
187:
188: TYPE Line_Tbl_Type IS TABLE OF Line_Rec_Type
189: INDEX BY BINARY_INTEGER;