DBA Data[Home] [Help]

APPS.JAI_CMN_ST_FORMS_PKG dependencies on PO_HEADERS_ALL

Line 74: from po_headers_all

70: and org_id = p_org_id;
71:
72: cursor c_get_po_num(p_po_header_id number) is
73: select segment1, type_lookup_code
74: from po_headers_all
75: where po_header_id = p_po_header_id;
76:
77: cursor c_get_focus_id(p_line_location_id number, p_line_id number) is
78: select line_focus_id

Line 145: v_po_num po_headers_all.segment1%type;

141: */
142: v_st_hdr_id JAI_CMN_STFORM_HDRS_ALL.st_hdr_id%type;
143: v_po_line_location_id JAI_AP_MATCH_INV_TAXES.line_location_id%type;
144: v_po_header_id JAI_AP_MATCH_INV_TAXES.po_header_id%type;
145: v_po_num po_headers_all.segment1%type;
146: v_po_line_id JAI_AP_MATCH_INV_TAXES.po_line_id%type;
147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
148: v_match_option po_line_locations_all.match_option%type;
149: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

Line 151: v_type_lookup_code po_headers_all.type_lookup_code%type;

147: v_tax_line_no JAI_PO_TAXES.tax_line_no%type;
148: v_match_option po_line_locations_all.match_option%type;
149: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
150: v_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
151: v_type_lookup_code po_headers_all.type_lookup_code%type;
152: v_tax_amount JAI_AP_MATCH_INV_TAXES.tax_amount%type;
153: v_doc_type varchar2(10);
154: v_tax_target_amount number;
155: v_st_dtl_id number;