Sunday, May 18, 2014

AR INV Validations

select ORGANIZATION_ID
  from hr_operating_units
 where name = 'Vision Operations';

--===============================================================================
 
SELECT *
  FROM RA_BATCH_SOURCES_ALL
 WHERE NAME = 'VISION BUILD'
   AND ORG_ID = 204;


--==============================================================================

select *
  from all_objects
 where object_type = 'TABLE'
   and object_name like '%REVENUE_ASSIGNMENTS%';
 
 
 
 SELECT *
   FROM AR_PAYMENT_SCHEDULES_ALL;
 
 
--=============================================================================

SELECT *
  FROM ra_cust_trx_types_all
 where NAME = 'Invoice'
   and ORG_ID =204;

--=============================================================================

SELECT *
  FROM AR_LOOKUPS
 WHERE MEANING ='Line'
   AND LOOKUP_TYPE = 'AR_LINE_INVOICE';
 
------------------------------------------------------------------------------
 select CURRENCY_CODE
   from fnd_currencies
  where CURRENCY_CODE = 'USD';

  =============================================================================

  select TERM_ID
    from ra_terms_tl
   where NAME = '30 NET';

--=============================================================================

select UOM_CODE
  from MTL_UNITS_OF_MEASURE_TL
 where UNIT_OF_MEASURE = 'Each';

--=============================================================================


SELECT *
  FROM HZ_PARTIES HP

===============================================================================

SELECT HCSU.site_use_code,HCSU.LOCATION,HCAS.cust_acct_site_id,HCA.cust_account_id,HP.PARTY_NUMBER, hp.PARTY_ID
FROM hz_parties HP
,hz_party_sites HPS
,hz_cust_accounts HCA
,hz_cust_acct_sites_all HCAS
,hz_cust_site_uses_all HCSU
WHERE HP.party_id = HPS.party_id
AND HCA.party_id = HP.party_id
AND HCA.cust_account_id = HCAS.cust_account_id
AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id
and hps.PARTY_SITE_ID = hcas.PARTY_SITE_ID
AND HCSU.site_use_code = 'SHIP_TO'
AND HP.PARTY_ID= 1290
AND HCAs.org_id = 204
AND LOCATION = 'Provo (OPS)';

===================================================================================


 select INVENTORY_ITEM_ID
   from mtl_system_items_b
  where segment1 = 'hpitem'
    and ORGANIZATION_ID = 204;
 
 ==============================================================================

 select conversion_type
from gl_daily_conversion_types
where conversion_type = 'User';

===============================================================================

SELECT LOOKUP_CODE
FROM fnd_lookup_values
WHERE lookup_type = 'FOB'
  and MEANING = 'Destination'
  AND VIEW_APPLICATION_ID =222;

==============================================================================

SELECT CODE_COMBINATION_ID
  FROM GL_CODE_COMBINATIONS_KFV
 WHERE CONCATENATED_SEGMENTS = '01-520-5250-0000-000';

select * from hz_locations where

select * from hz_party_sites


select *
from fnd_applications



SELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID =5903782;

DELETE FND_CONCURRENT_REQUESTS WHERE REQUEST_ID =5903786;
















 
   
   RA_CUSTOMER_TRX_V
 
   RA_CUSTOMER_TRX_LINES_V
 
select *
  from ra_customer_trx_all where SHIP_TO_CUSTOMER_ID=1290


No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...