DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on PO_VENDORS

Line 726: l_supplier_num po_vendors.segment1%TYPE;

722: AND R.je_header_id = p_journal_rec.je_header_id
723: AND R.je_line_num = p_journal_rec.je_line_num;
724:
725:
726: l_supplier_num po_vendors.segment1%TYPE;
727:
728: BEGIN
729:
730: g_error_exists := 'FALSE';

Line 777: FROM jl_co_gl_nits jlcgn, po_vendors pov

773: g_nit_rec.nit_name,
774: g_nit_rec.nit_type,
775: g_nit_rec.verifying_digit,
776: l_supplier_num
777: FROM jl_co_gl_nits jlcgn, po_vendors pov
778: WHERE NVL(l_supplier_num,TO_CHAR(ap_trx.party_id)) =
779: DECODE(l_supplier_num, NULL,TO_CHAR(pov.vendor_id),pov.segment1)
780: AND jlcgn.nit(+) = REPLACE(pov.num_1099,'-') ; */
781:

Line 1231: l_customer_num po_vendors.segment1%TYPE;

1227: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1228: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1229: l_ent_dr gl_je_lines.entered_dr%TYPE;
1230: l_ent_cr gl_je_lines.entered_cr%TYPE;
1231: l_customer_num po_vendors.segment1%TYPE;
1232: l_identifier_type VARCHAR2(30);
1233: l_country_code varchar2(30);
1234: l_branch_country_code varchar2(60);
1235: l_party_id number;