APPS.OZF_ACCT_GENERATOR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

SELECT employee_id
FROM   fnd_user
WHERE  user_id = p_user_id ;

Line: 96

select f.ded_adjustment_account
,      f.accrued_liable_account
,      c.ded_adjustment_account
,      c.accrued_liability_account
from   ozf_funds_all_b f
,      ams_categories_b c
where  f.category_id = c.category_id
and    f.fund_id = p_budget_id;

Line: 107

select osp.gl_id_ded_adj            -- expense account
,      osp.gl_id_accr_promo_liab    -- accrual liability account
,      osp.gl_id_ded_clearing       -- vendor clearing account
,      osp.gl_rec_clearing_account  -- receivables clearing account
FROM   ozf_sys_parameters_all osp
--,      ozf_funds_utilized_all_b ofa
,      ozf_funds_all_b f
WHERE  osp.org_id = NVL(f.org_id, -99)
--AND    ofa.fund_id = f.fund_id
AND    f.fund_id = p_id;

Line: 343

   SELECT HEADER_ID,
          LINE_ID
   FROM   OE_PRICE_ADJUSTMENTS
   WHERE  PRICE_ADJUSTMENT_ID = p_price_adj_id;

Line: 349

   SELECT HEADER_ID,
          ORG_ID,
          SHIP_FROM_ORG_ID,
          SOLD_TO_ORG_ID,
          COMMITMENT_ID,
          SALESREP_ID,
          INVENTORY_ITEM_ID,
          ITEM_TYPE_CODE
   FROM   oe_order_lines_all
   WHERE  LINE_ID = p_line_id;

Line: 361

   SELECT HEADER_ID,
          ORG_ID,
          SHIP_FROM_ORG_ID,
          SOLD_TO_ORG_ID,
          SALESREP_ID
   FROM   oe_order_headers_all
   WHERE  HEADER_ID = p_header_id;

Line: 370

   SELECT REFERENCE_LINE_ID,
          LINE_CATEGORY_CODE
   FROM   OE_ORDER_LINES_ALL
   WHERE  LINE_ID = p_line_id;

Line: 376

   SELECT ORDER_CATEGORY_CODE,
          ORDER_TYPE_ID
   FROM   OE_ORDER_HEADERS_ALL
   WHERE  HEADER_ID = p_header_id;

Line: 382

   SELECT org_id
   FROM   ozf_funds_all_b
   WHERE  fund_id = p_budget_id;

Line: 387

   SELECT org_id
   FROM   ozf_claims_all
   WHERE  claim_id = p_claim_id;

Line: 392

   select chart_of_accounts_id
   from   gl_sets_of_books sob
   ,      ozf_sys_parameters_all osp
   where  osp.set_of_books_id = sob.set_of_books_id
   and    osp.org_id = NVL(p_org_id, -99);

Line: 399

   SELECT 1
   FROM   ozf_funds_utilized_all_b
   WHERE  utilization_id = p_utilization_id
   AND    object_type = 'TP_ORDER';

Line: 879

SELECT   LINK_TO_LINE_ID,
         ITEM_TYPE_CODE
FROM     OE_ORDER_LINES_ALL
WHERE    LINE_ID = p_line_id;

Line: 885

SELECT  NVL(M.COST_OF_SALES_ACCOUNT,0)
FROM    OE_ORDER_LINES_ALL OL,
           MTL_SYSTEM_ITEMS M
WHERE   OL.LINE_ID = p_line_id
AND     M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID
AND     M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID;

Line: 894

SELECT  NVL(COST_OF_SALES_ACCOUNT,0)
FROM    MTL_SYSTEM_ITEMS
WHERE   INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
AND     ORGANIZATION_ID = P_ORGANIZATION_ID;