eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on OE_ORDER_LINES_ALL

Line 626: ,oe_order_lines_all sol

622: ,1
623: ,sol.pricing_quantity_uom) exchange_UOM-- returns qty in primary UOM for 1 UOM in document
624: ,sol.line_id
625: FROM oe_order_headers_all soh
626: ,oe_order_lines_all sol
627: ,hr_all_organization_units_tl haotl
628: --updated to fix project_number related issue start
629: --,pa_projects_all pa
630: --updated to fix project_number related issue end

Line 893: l_rcv_line_id oe_order_lines_all.line_id%TYPE;

889: -- l_start_date DATE;
890: -- l_end_date DATE;
891: -- l_set_of_book_id NUMBER;
892: l_transaction_id rcv_transactions.transaction_id%TYPE;
893: l_rcv_line_id oe_order_lines_all.line_id%TYPE;
894: l_reference_line_id oe_order_lines_all.reference_line_id%TYPE;
895: l_org_id NUMBER;
896: l_cur_rcv_order_number oe_order_headers_all.order_number%TYPE;
897: l_cur_rcv_line_number oe_order_lines_all.line_number%TYPE;

Line 894: l_reference_line_id oe_order_lines_all.reference_line_id%TYPE;

890: -- l_end_date DATE;
891: -- l_set_of_book_id NUMBER;
892: l_transaction_id rcv_transactions.transaction_id%TYPE;
893: l_rcv_line_id oe_order_lines_all.line_id%TYPE;
894: l_reference_line_id oe_order_lines_all.reference_line_id%TYPE;
895: l_org_id NUMBER;
896: l_cur_rcv_order_number oe_order_headers_all.order_number%TYPE;
897: l_cur_rcv_line_number oe_order_lines_all.line_number%TYPE;
898: l_cur_rcv_ordered_quantity NUMBER;

Line 897: l_cur_rcv_line_number oe_order_lines_all.line_number%TYPE;

893: l_rcv_line_id oe_order_lines_all.line_id%TYPE;
894: l_reference_line_id oe_order_lines_all.reference_line_id%TYPE;
895: l_org_id NUMBER;
896: l_cur_rcv_order_number oe_order_headers_all.order_number%TYPE;
897: l_cur_rcv_line_number oe_order_lines_all.line_number%TYPE;
898: l_cur_rcv_ordered_quantity NUMBER;
899: l_cur_rcv_shipped_quantity NUMBER;
900: l_creation_date DATE;
901:

Line 918: ,oe_order_lines_all oel

914: ,haotl.NAME
915: ,rcv.creation_date
916: ,rcv.transaction_id
917: FROM rcv_transactions rcv
918: ,oe_order_lines_all oel
919: ,oe_order_headers_all oeh
920: ,hr_all_organization_units_tl haotl
921: WHERE oel.org_id = lp_org_id
922: AND rcv.transaction_type = 'DELIVER'

Line 948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;

944: l_item_id jmf_shikyu_cur_rpt_temp.item_id%TYPE;
945: l_item_name jmf_shikyu_cur_rpt_temp.item_name%TYPE;
946: l_item_desc jmf_shikyu_cur_rpt_temp.item_desc%TYPE;
947: l_quantity jmf_shikyu_cur_rpt_temp.quantity%TYPE;
948: l_flow_status_code oe_order_lines_all.flow_status_code%TYPE;
949: l_unit_cost_frozen jmf_shikyu_cur_rpt_temp.unit_cost_frozen%TYPE;
950: l_unit_cost_plan jmf_shikyu_cur_rpt_temp.unit_cost_plan%TYPE;
951: l_primary_qty jmf_shikyu_cur_rpt_temp.primary_qty%TYPE;
952: l_func_currency_code jmf_shikyu_cur_rpt_temp.func_currency_code%TYPE;

Line 1068: ,oe_order_lines_all sol

1064: ,l_flow_status_code
1065: ,l_om_ship_from_org_id
1066: ,l_actual_shipment_date
1067: FROM oe_order_headers_all soh
1068: ,oe_order_lines_all sol
1069: ,pa_projects_all pa
1070: ,pa_tasks tasks
1071: ,jmf_shikyu_replenishments repo
1072: ,mtl_system_items_vl mtl