6528: l_source_type t_source_type;
6529: l_organization_id t_organization_id;
6530: l_mtl_organization_id t_mtl_organization_id;
6531:
6532: l_orgn_code_pri GL_ACCT_HRC.ORGN_CODE_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6529: l_organization_id t_organization_id;
6530: l_mtl_organization_id t_mtl_organization_id;
6531:
6532: l_orgn_code_pri GL_ACCT_HRC.ORGN_CODE_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6530: l_mtl_organization_id t_mtl_organization_id;
6531:
6532: l_orgn_code_pri GL_ACCT_HRC.ORGN_CODE_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6531:
6532: l_orgn_code_pri GL_ACCT_HRC.ORGN_CODE_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6532: l_orgn_code_pri GL_ACCT_HRC.ORGN_CODE_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6533: l_whse_code_pri GL_ACCT_HRC.WHSE_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6534: l_item_pri GL_ACCT_HRC.ITEM_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6535: l_vendor_pri GL_ACCT_HRC.VENDOR_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6536: l_customer_pri GL_ACCT_HRC.CUSTOMER_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6537: l_reason_code_pri GL_ACCT_HRC.REASON_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6538: l_icgl_class_pri GL_ACCT_HRC.ICGL_CLASS_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6539: l_vendgl_class_pri GL_ACCT_HRC.VENDGL_CLASS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6540: l_custgl_class_pri GL_ACCT_HRC.CUSTGL_CLASS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6541: l_currency_code_pri GL_ACCT_HRC.CURRENCY_CODE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6542: l_routing_pri GL_ACCT_HRC.ROUTING_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6543: l_charge_pri GL_ACCT_HRC.CHARGE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6544: l_tax_auth_pri GL_ACCT_HRC.TAX_AUTH_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6545: l_aqui_cost_code_pri GL_ACCT_HRC.AQUI_COST_CODE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6546: l_resource_pri GL_ACCT_HRC.RESOURCE_PRI%TYPE := 0;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6554: l_co_code1 GL_ACCT_HRC.CO_CODE%TYPE;
6547: l_cost_cmpntcls_pri GL_ACCT_HRC.COST_CMPNTCLS_PRI%TYPE := 0;
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6554: l_co_code1 GL_ACCT_HRC.CO_CODE%TYPE;
6555:
6548: l_cost_analysis_pri GL_ACCT_HRC.COST_ANALYSIS_PRI%TYPE := 0;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6554: l_co_code1 GL_ACCT_HRC.CO_CODE%TYPE;
6555:
6556: l_reason_id MTL_TRANSACTION_REASONS.REASON_ID%TYPE;
6549: l_order_type_pri GL_ACCT_HRC.ORDER_TYPE_PRI%TYPE := 0;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6554: l_co_code1 GL_ACCT_HRC.CO_CODE%TYPE;
6555:
6556: l_reason_id MTL_TRANSACTION_REASONS.REASON_ID%TYPE;
6557: l_row_id ROWID;
6550: l_gl_business_class_pri GL_ACCT_HRC.GL_BUSINESS_CLASS_PRI%TYPE := 0;
6551: l_gl_product_line_pri GL_ACCT_HRC.GL_PRODUCT_LINE_PRI%TYPE := 0;
6552: l_line_type_pri GL_ACCT_HRC.LINE_TYPE_PRI%TYPE := 0;
6553: l_ar_trx_type_pri GL_ACCT_HRC.AR_TRX_TYPE_PRI%TYPE := 0;
6554: l_co_code1 GL_ACCT_HRC.CO_CODE%TYPE;
6555:
6556: l_reason_id MTL_TRANSACTION_REASONS.REASON_ID%TYPE;
6557: l_row_id ROWID;
6558:
7543: a.gl_business_class_pri,
7544: a.gl_product_line_pri,
7545: a.line_type_pri,
7546: a.ar_trx_type_pri
7547: FROM gl_acct_hrc a
7548: WHERE a.acct_ttl_type = :p_acct_ttl_type
7549: AND a.co_code = :p_co_code
7550: ORDER BY 1 desc';
7551: BEGIN