APPS.FV_STATUS_OF_OBLIGATIONS dependencies on PO_DISTRIBUTIONS

Line 57: po_distributions.po_distribution_id%type ;

53: v_obligamt number;
54: v_obligccid number;
55: v_obligstatus po_lines.closed_code%type;
56: v_inv_po_distribution_id
57: po_distributions.po_distribution_id%type ;
58: v_po_req_distribution_id
59: po_req_distributions.distribution_id%type ;
60: v_po_distribution_id po_distributions.po_distribution_id%type ;
61:

Line 60: v_po_distribution_id po_distributions.po_distribution_id%type ;

56: v_inv_po_distribution_id
57: po_distributions.po_distribution_id%type ;
58: v_po_req_distribution_id
59: po_req_distributions.distribution_id%type ;
60: v_po_distribution_id po_distributions.po_distribution_id%type ;
61:
62: v_invnum ap_invoices.invoice_num%type;
63: v_invdate date;
64: v_invamt number;

Line 299: po_distributions pod,

295:
296: from po_headers poh,
297: po_lines pol,
298: po_line_locations poll,
299: po_distributions pod,
300: gl_code_combinations glcc
301:
302: where poh.approved_flag = 'Y'
303: and pod.po_distribution_id = v_inv_po_distribution_id

Line 538: po_distributions pod,

534: pod.po_distribution_id' || v_val_string ||
535: ' from po_headers poh,
536: po_lines pol,
537: po_line_locations poll,
538: po_distributions pod,
539: gl_code_combinations glcc
540: where
541: NOT EXISTS( Select 1
542: from fv_status_oblig_temp fvs