DBA Data[Home] [Help]

APPS.RCV_ACCRUALUTILITIES_GRP dependencies on CST_ORGANIZATION_DEFINITIONS

Line 177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;

173:
174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
180: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%TYPE;

Line 178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;

174: l_rcv_organization_id RCV_TRANSACTIONS.organization_id%TYPE;
175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
180: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%TYPE;
182:

Line 179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;

175: l_po_header_id RCV_TRANSACTIONS.po_header_id%TYPE;
176: l_po_org_id PO_HEADERS_ALL.org_id%TYPE;
177: l_po_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
178: l_rcv_org_id CST_ORGANIZATION_DEFINITIONS.operating_unit%TYPE;
179: l_rcv_sob_id CST_ORGANIZATION_DEFINITIONS.set_of_books_id%TYPE;
180: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
181: l_lcm_flag PO_LINE_LOCATIONS_ALL.lcm_flag%TYPE;
182:
183: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;

Line 287: FROM cst_organization_definitions cod

283: /* Get Receiving Operating Unit and Set of Books */
284: l_stmt_num := 30;
285: SELECT operating_unit, set_of_books_id
286: INTO l_rcv_org_id, l_rcv_sob_id
287: FROM cst_organization_definitions cod
288: WHERE organization_id = l_rcv_organization_id;
289:
290: IF l_sLog THEN
291: l_api_message := 'l_rcv_org_id : '|| l_rcv_org_id || '; l_rcv_sob_id : ' || l_rcv_sob_id;