DBA Data[Home] [Help]

APPS.FV_STATUS_OF_OBLIGATIONS dependencies on PO_HEADERS

Line 51: v_oblignum po_headers.segment1%type;

47: v_reqdate date;
48: v_reqamt number;
49: v_reqccid number;
50:
51: v_oblignum po_headers.segment1%type;
52: v_obligdate date;
53: v_obligamt number;
54: v_obligccid number;
55: v_obligstatus po_lines.closed_code%type;

Line 296: from po_headers poh,

292: v_obligccid ,
293: v_po_req_distribution_id,
294: v_po_distribution_id
295:
296: from po_headers poh,
297: po_lines pol,
298: po_line_locations poll,
299: po_distributions pod,
300: gl_code_combinations glcc

Line 311: from po_headers A

307: and pod.code_combination_id = glcc.code_combination_id
308: and pod.set_of_books_id = v_set_of_books_id
309: and not exists
310: (select 1
311: from po_headers A
312: where A.segment1 = poh.segment1
313: and poh.type_lookup_code = 'PLANNED'
314: and pod.source_distribution_id is NULL);
315: /* and not exists

Line 535: ' from po_headers poh,

531: pol.closed_code,
532: pod.code_combination_id,
533: pod.req_distribution_id,
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

Line 550: from po_headers A

546: and pol.po_line_id = poll.po_line_id
547: and poll.line_location_id = pod.line_location_id
548: and not exists
549: (select 1
550: from po_headers A
551: where A.segment1 = poh.segment1
552: and poh.type_lookup_code = '||''''||'PLANNED'||''''||
553: ' and pod.source_distribution_id is NULL)
554: and pod.set_of_books_id = :b_set_of_books_id