DBA Data[Home] [Help]

APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 475: ' AR_SYSTEM_PARAMETERS_ALL aspa,'||

471: ' nvl(opa.charge_adjamt,0)*l.ordered_quantity + nvl(opa.charge_operand,0) FREIGHT_CHARGE,'||
472: ' opa.cost FREIGHT_COST'||
473: ' FROM OE_ORDER_HEADERS_ALL h,'||
474: ' OE_ORDER_LINES_ALL l,'||
475: ' AR_SYSTEM_PARAMETERS_ALL aspa,'||
476: ' GL_SETS_OF_BOOKS gsb,'||
477: ' HR_ORGANIZATION_INFORMATION hoi,'||
478: ' OE_SYS_PARAMETERS_ALL ospa,'||
479: ' GL_SETS_OF_BOOKS gsb1,'||

Line 819: AR_SYSTEM_PARAMETERS_ALL aspa,

815: group by p.line_id) opa,
816: (select /*+ no_merge cardinality (ilog, 1000)*/ distinct line_id, header_id from isc_dbi_change_log ilog) log,
817: oe_order_lines_all l,
818: OE_ORDER_HEADERS_ALL h,
819: AR_SYSTEM_PARAMETERS_ALL aspa,
820: GL_SETS_OF_BOOKS gsb,
821: HR_ORGANIZATION_INFORMATION hoi,
822: OE_SYS_PARAMETERS_ALL ospa,
823: GL_SETS_OF_BOOKS gsb1,

Line 931: -- AR_SYSTEM_PARAMETERS_ALL aspa,

927: -- pl.service_number LINE_NUMBER
928: -- FROM (SELECT distinct top_model_line_id FROM isc_tmp_book_sum2) log,
929: -- oe_order_lines_all pl,
930: -- OE_ORDER_HEADERS_ALL h,
931: -- AR_SYSTEM_PARAMETERS_ALL aspa,
932: -- GL_SETS_OF_BOOKS gsb,
933: -- HR_ORGANIZATION_INFORMATION hoi,
934: -- OE_SYSTEM_PARAMETERS_ALL ospa,
935: -- GL_SETS_OF_BOOKS gsb1,