Monday 31 October 2011

JobCode_Cost_

Select MATCH_OPTION from po_line_locations_all where po_line_id=137873
Select * from pa_projects_all
Select * from all_objects where object_name like '%PROJECTS%'
Select * from FND_FLEX_VALUES_VL where flex_value_set_id ='1005233'
Select * from fnd_flex_values where flex_value_id=33584
Select * from fnd_flex_values_tl where flex_value_id=33584
Select * from gl_code_combinations_kfv where segment6='103P' and segment1='42'
/* Formatted on 31-08-2011 15:39:43 (QP5 v5.115.810.9015) */
/* Formatted on 31-08-2011 15:40:41 (QP5 v5.115.810.9015) */
SELECT   DISTINCT hou.name Operating_unit,
                  glcc.segment6 job_code,
                  aia.invoice_num,
                  aia.INVOICE_DATE,
                  aia.INVOICE_TYPE_LOOKUP_CODE,
                  aia.GL_DATE,
                  aia.invoice_amount,
                  glcc.CONCATENATED_SEGMENTS Acct_Code
  FROM   gl_code_combinations_kfv glcc,
         ap_invoices_all aia,
         ap_invoice_distributions_All aid,
         hr_operating_units hou
 WHERE       aia.set_of_books_id = 5
         AND aid.DIST_CODE_COMBINATION_ID = glcc.CODE_COMBINATION_ID
         AND aia.invoice_id = aid.invoice_id
         AND aia.org_id = aid.org_id
         AND hou.organization_id = aia.org_id
         AND glcc.segment6 IN
                  ('103P',
                   '111P ',
                   '114P ',
                   '112P ',
                   '101P',
                   '102P',
                   '104P',
                   '105P',
                   '106P',
                   '106P',
                   '110P',
                   '104P',
                   '105P',
                   '109P',
                   '55CC',
                   '54CC',
                   '63CC',
                   '57CC',
                   '58CC',
                   '61CC',
                   '62CC',
                   '59CC',
                   '103P',
                   '50CC')

No comments:

Post a Comment