APPS.FV_STATUS_OF_OBLIGATIONS dependencies on GL_CODE_COMBINATIONS

Line 191: gl_code_combinations glcc

187: apd.dist_code_combination_id,
188: apd.po_distribution_id ' || v_val_string
189: || ' from ap_invoice_distributions apd,
190: ap_invoices api,
191: gl_code_combinations glcc
192: where api.invoice_id = apd.invoice_id
193: and glcc.code_combination_id = apd.dist_code_combination_id
194: and (api.invoice_date between :b_from_period and :b_to_period)
195: and api.set_of_books_id = :b_set_of_books_id '|| v_where ;

Line 300: gl_code_combinations glcc

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
304: and poh.po_header_id = pol.po_header_id

Line 369: gl_code_combinations glcc

365:
366: from po_requisition_headers porh,
367: po_requisition_lines porl,
368: po_req_distributions pord,
369: gl_code_combinations glcc
370:
371: where pord.distribution_id = v_po_req_distribution_id
372: and porh.requisition_header_id =
373: porl.requisition_header_id

Line 539: gl_code_combinations glcc

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
543: where fvs.po_distribution_id = pod.po_distribution_id)

Line 657: gl_code_combinations glcc

653:
654: from po_requisition_headers porh,
655: po_requisition_lines porl,
656: po_req_distributions pord,
657: gl_code_combinations glcc
658:
659: where pord.distribution_id = v_po_req_distribution_id
660: and porh.requisition_header_id = porl.requisition_header_id
661: and porl.requisition_line_id = pord.requisition_line_id