+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
The following is a Query to get PR and PO Details

Code sql:
SELECT poh.segment1 po_number, pol.line_num, pol.item_description,
       ploc.quantity, mtl.segment1 || ',' || mtl.segment2 po_item,
       prh.segment1 req_num, fnd.user_name requestor, prl.need_by_date
...
Read More Read More
Published by
The following is a Query To get List of Employees which Dont have Supervisors.


Code sql:
SELECT ppf.full_name
  FROM per_all_people_f ppf
      ,per_all_assignments_f paaf
 WHERE 1=1
   AND ppf.person_id=paaf.person_id
   AND ppf.employee_number IS NOT
...
Read More Read More
Published by
The following is a Query To get List of Employees which has Supervisors.

Code sql:
SELECT ppf.full_name emp_name
      ,ppf1.full_name supervisor_name
FROM per_all_people_f ppf
,per_all_assignments_f paaf
,per_all_people_f ppf1
WHERE 1=1
AND ppf.person_id=paaf.person_id
...
Read More Read More 2 Comments
Published by
Introduction

API to Create AR Receipts

The code

Below script is used to create AR receipt that is not specific to any customers. The receipt created can be applied to any specific customers.


Code sql:
 
DECLARE
...
Read More Read More
Published by
Introduction

API to Apply AR Receipts


The code

This script is used to Apply an AR Receipt that is already created to a Customer Transaction.

Code sql:
 
DECLARE
    --local Variables
	g_loc               		NUMBER :=0;
...
Read More Read More
Published by
Introduction

While creating setup for OLM, there is requirement for creating cataloge objects. Course is of the main component for OLM Cataloge objects. Here in this article, i am explaining Course Creation API by providing a copy of working example for it.

Background ...
Read More Read More
Published by
Introduction

This article explains how to customize defaulting logic of Requisitions/Lines and Distributions.

Background

For defaulting any column values of requisitions, requisition lines or requisition distributions during the time or creation, a specific ...
Read More Read More
Published by
This is a Query To Display Vendor wise Remit To Bank Account Number

Code sql:
SELECT DISTINCT pv.vendor_name,
            ie.masked_bank_account_num,
            invoice_num,
           cb.bank_name
  FROM po_vendors pv,
           ap_invoices_all ap,
...
Read More Read More
Published by
Introduction

Function to find PO number for a Requisition.

The code

Code sql:
 
CREATE OR REPLACE FUNCTION	XXC_GETPO( p_req_num	IN	VARCHAR2)
RETURN NUMBER
IS
	l_po_num	VARCHAR2(20);
BEGIN
	SELECT DISTINCT	PH.segment1
...
Read More Read More
Published by
The following is a test case Query to insert or display serial numbers in Oracle.

Code sql:
CREATE TABLE test(sno NUMBER);

Here I am inserting 9 crore records.

Code sql:
DECLARE
a NUMBER;
BEGIN
FOR i IN 1..90000000 loop
INSERT INTO test3 VALUES(i);
...
Read More Read More 1 Comment

Page 1 of 10 1 2 3 4 5 6 7