Monday, 30 October 2017

ISO Receipt Register -GST Query

›
SELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid,        send_orgname, recv_orgid, recv_org_name, gst_no, se...
1 comment:

Query to Fetch Invoice details, HSN Code, Third party Registration number and GST Details.

›
The below query fetches the details of an Invoice along with the HSN Code of  a respective item present in an Invoice. GST details can also...
5 comments:
Wednesday, 25 October 2017

Return To Vendor Summay-GST

›
The below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because ...
1 comment:

TAX INVOICE RCM(REVERSE CHARGE MECHANISM) - GST

›
The below query fetches the details of a tax invocie  where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax pa...
1 comment:
Tuesday, 24 October 2017

Delivery Challan with GST Details

›
Query retrieves data of those inventory items which are used for promotional purposes or given as a sample items for a sales executive in ...
1 comment:
Thursday, 19 October 2017

Oracle Fusion HCM Data Loader (HDL) Keys Significance

›
HCM Data Loader (HDL) Keys Supported Key Types: HCM Data Loader (HDL) supports 4 different types of keys as listed below  GUID – O...
11 comments:

Oracle Apps(EBS) - AR Receipt Register Query with Bank statement Header and Line Details

›
Below query is useful when you required  Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receip...