DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on PO_LINE_LOCATIONS_ALL

Line 54: cancel_flag po_line_locations_all.cancel_flag%TYPE,

50: taxable_flag po_line_locations.taxable_flag%TYPE,
51: note_to_vendor po_lines_all.note_to_vendor%TYPE,
52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,

Line 55: cancel_date po_line_locations_all.cancel_date%TYPE,

51: note_to_vendor po_lines_all.note_to_vendor%TYPE,
52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,

Line 56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,

52: un_number_id po_lines_all.un_number_id%TYPE,
53: hazard_class_id po_lines_all.hazard_class_id%TYPE,
54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,

Line 58: org_id po_line_locations_all.org_id%TYPE,

54: cancel_flag po_line_locations_all.cancel_flag%TYPE,
55: cancel_date po_line_locations_all.cancel_date%TYPE,
56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --

Line 60: line_location_id po_line_locations_all.line_location_id%TYPE,

56: quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE,
57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */

Line 61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,

57: item_id po_lines_all.item_id%TYPE,
58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */
65: --

Line 62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --

58: org_id po_line_locations_all.org_id%TYPE,
59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */
65: --
66: from_header_id po_lines_all.from_header_id%type,

Line 63: start_date po_line_locations_all.start_date%TYPE, /* */

59: contract_num po_lines_all.contract_num%TYPE,
60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */
65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,

Line 64: end_date po_line_locations_all.end_date%TYPE, /* */

60: line_location_id po_line_locations_all.line_location_id%TYPE,
61: ship_to_location_id po_line_locations_all.ship_to_location_id%TYPE,
62: consigned_flag po_line_locations_all.consigned_flag%TYPE, --
63: start_date po_line_locations_all.start_date%TYPE, /* */
64: end_date po_line_locations_all.end_date%TYPE, /* */
65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
68: --

Line 69: drop_ship_flag po_line_locations_all.drop_ship_flag%TYPE --Bug 9356725

65: --
66: from_header_id po_lines_all.from_header_id%type,
67: from_line_id po_lines_all.from_line_id%TYPE,
68: --
69: drop_ship_flag po_line_locations_all.drop_ship_flag%TYPE --Bug 9356725
70: );
71:
72:
73: procedure generate_html (document_id in varchar2,

Line 125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;

121: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;

Line 126: l_cancel_date po_line_locations_all.cancel_date%TYPE;

122: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;

Line 127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;

123: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
124: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
125: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
126: l_cancel_date po_line_locations_all.cancel_date%TYPE;
127: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
128:
129: l_requestor_name po_distributions_print.requestor_name%TYPE;
130: l_requestor_id po_distributions_print.requestor_id%TYPE;
131: