APPS.ISC_DEPOT_MARGIN_ETL_PKG dependencies on ISC_DR_REPAIR_ORDERS_F

Line 197: isc_dr_repair_orders_f rof

193: + nvl(pl_overhead_in,0)
194: + nvl(tl_outside_processing_in,0)
195: + nvl(pl_outside_processing_in,0) ) expense_cost_b
196: from
197: isc_dr_repair_orders_f rof
198: , csd_repair_job_xref crjx
199: , wip_period_balances wpb
200: , ( select wip_entity_id
201: from csd_repair_job_xref xref

Line 254: isc_dr_repair_orders_f rof

250: + nvl(tl_outside_processing_in,0)
251: + nvl(pl_outside_processing_in,0)
252: ) expense_cost_b
253: from
254: isc_dr_repair_orders_f rof
255: , csd_repair_job_xref crjx
256: , wip_period_balances wpb
257: , ( select wip_entity_id
258: from csd_repair_job_xref xref

Line 505: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

501: bis_collection_utilities.log( 'Truncated table ISC_DR_CHARGES_F', 1 );
502:
503: l_stmnt_id := 40;
504: if isc_depot_backlog_etl_pkg.get_last_run_date
505: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
506: , x_run_date => l_ro_last_run_date
507: , x_message => l_message
508: ) <> c_ok then
509: raise l_exception;

Line 590: , isc_dr_repair_orders_f rof

586: , g_program_application_id program_application_id
587: , g_request_id request_id
588: from
589: csd_repair_actuals cra
590: , isc_dr_repair_orders_f rof
591: , csd_repair_actual_lines cral
592: , cs_estimate_details ced
593: , isc_book_sum2_f ibsf
594: , cs_txn_billing_types ctbt

Line 757: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

753: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_F', 1 );
754:
755: l_stmnt_id := 60;
756: if isc_depot_backlog_etl_pkg.get_last_run_date
757: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
758: , x_run_date => l_ro_last_run_date
759: , x_message => l_message
760: ) <> c_ok then
761: raise l_exception;

Line 962: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

958: bis_collection_utilities.log( 'Secondary Global Currency Rate Type: ' || g_global_sec_rate_type, 1 );
959:
960: l_stmnt_id := 20;
961: if isc_depot_backlog_etl_pkg.get_last_run_date
962: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
963: , x_run_date => l_ro_last_run_date
964: , x_message => l_message
965: ) <> c_ok then
966: raise l_exception;

Line 1042: isc_dr_repair_orders_f rof

1038: , g_program_login_id program_login_id
1039: , g_program_application_id program_application_id
1040: , g_request_id request_id
1041: from
1042: isc_dr_repair_orders_f rof
1043: , cs_estimate_details ced
1044: , csd_repair_actuals cra
1045: , csd_repair_actual_lines cral
1046: , cs_txn_billing_types ctbt

Line 1237: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'

1233: bis_collection_utilities.log( 'Truncated table ISC_DR_COSTS_CONV_TMP', 1 );
1234:
1235: l_stmnt_id := 40;
1236: if isc_depot_backlog_etl_pkg.get_last_run_date
1237: ( p_fact_name => 'ISC_DR_REPAIR_ORDERS_F'
1238: , x_run_date => l_ro_last_run_date
1239: , x_message => l_message
1240: ) <> c_ok then
1241: raise l_exception;