DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on PO_HEADERS_ALL

Line 90: from po_headers_all

86: and org_id = p_org_id;
87:
88: cursor c_get_po_num(p_po_header_id number) is
89: select segment1, type_lookup_code
90: from po_headers_all
91: where po_header_id = p_po_header_id;
92:
93: cursor c_get_focus_id(p_line_location_id number, p_line_id number) is
94: select line_focus_id

Line 161: v_po_num po_headers_all.segment1%type;

157: */
158: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
159: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
160: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
161: v_po_num po_headers_all.segment1%type;
162: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

Line 167: v_type_lookup_code po_headers_all.type_lookup_code%type;

163: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
164: v_match_option po_line_locations_all.match_option%type;
165: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
166: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
167: v_type_lookup_code po_headers_all.type_lookup_code%type;
168: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
169: v_doc_type varchar2(10);
170: v_tax_target_amount number;
171: v_st_dtl_id number;