2123: FROM HZ_PARTIES part
2124: WHERE part.party_id = pn_supplier_id --parameter: pn_supplier_id
2125: UNION
2126: SELECT Sup.Segment1 Supplier_Number
2127: FROM ap_suppliers Sup
2128: WHERE Sup.vendor_id = pn_supplier_id; --parameter: pn_supplier_id
2129:
2130: BEGIN
2131: --logging for debug
2247: Gl_Ledgers Gl,
2248: Gl_Periods Gp,
2249: Xla_Ae_Lines Ael,
2250: Xla_Ae_Headers Aeh,
2251: Ap_Suppliers Sup
2252: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
2253: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
2254: AND Gir.Je_Line_Num = Jel.Je_Line_Num
2255: AND Jcc.Code_Combination_Id = Jel.Code_Combination_Id
2656: Gl_Ledgers Gl,
2657: Gl_Periods Gp,
2658: Xla_Ae_Lines Ael,
2659: Xla_Ae_Headers Aeh,
2660: Ap_Suppliers Sup,
2661: Fnd_Currencies_Vl Fcv
2662: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id
2663: AND Gir.Je_Header_Id = Jeh.Je_Header_Id
2664: AND Gir.Je_Line_Num = Jel.Je_Line_Num