DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_HEADERS_ALL

Line 971: from po_headers_all

967: select
968: po_header_id,
969: segment1,
970: trunc(creation_date) po_date
971: from po_headers_all
972: where po_header_id =
973: ( select po_header_id
974: from po_distributions_all
975: where po_distribution_id = p_po_distribution_id);

Line 1118: v_po_header_id po_headers_all.po_header_id%type;

1114:
1115:
1116:
1117: v_run_no number;
1118: v_po_header_id po_headers_all.po_header_id%type;
1119: v_po_number po_headers_all.segment1%type;
1120: v_po_date date;
1121: v_receipt_num rcv_shipment_headers.receipt_num%type;
1122: v_receipt_date date;

Line 1119: v_po_number po_headers_all.segment1%type;

1115:
1116:
1117: v_run_no number;
1118: v_po_header_id po_headers_all.po_header_id%type;
1119: v_po_number po_headers_all.segment1%type;
1120: v_po_date date;
1121: v_receipt_num rcv_shipment_headers.receipt_num%type;
1122: v_receipt_date date;
1123: v_tax_type JAI_CMN_TAXES_ALL.tax_type%type;