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.CSD_UPDATE_PROGRAMS_PVT dependencies on CS_ESTIMATE_DETAILS

Line 47: estimate_quantity cs_estimate_details.quantity_required%type ,

43: action_type csd_product_transactions.action_type%type, --bug#10099900
44: source_serial_number csd_product_transactions.source_serial_number%type,
45: source_instance_id csd_product_transactions.source_instance_id%type,
46: prod_txn_recd_qty csd_product_transactions.quantity_received%type,
47: estimate_quantity cs_estimate_details.quantity_required%type ,
48: est_order_line_id cs_estimate_details.order_line_id%type ,
49: prod_txn_item_id cs_estimate_details.inventory_item_id%type
50: );
51:

Line 48: est_order_line_id cs_estimate_details.order_line_id%type ,

44: source_serial_number csd_product_transactions.source_serial_number%type,
45: source_instance_id csd_product_transactions.source_instance_id%type,
46: prod_txn_recd_qty csd_product_transactions.quantity_received%type,
47: estimate_quantity cs_estimate_details.quantity_required%type ,
48: est_order_line_id cs_estimate_details.order_line_id%type ,
49: prod_txn_item_id cs_estimate_details.inventory_item_id%type
50: );
51:
52: TYPE IO_RCPT_LINES_Rec_Type IS RECORD

Line 49: prod_txn_item_id cs_estimate_details.inventory_item_id%type

45: source_instance_id csd_product_transactions.source_instance_id%type,
46: prod_txn_recd_qty csd_product_transactions.quantity_received%type,
47: estimate_quantity cs_estimate_details.quantity_required%type ,
48: est_order_line_id cs_estimate_details.order_line_id%type ,
49: prod_txn_item_id cs_estimate_details.inventory_item_id%type
50: );
51:
52: TYPE IO_RCPT_LINES_Rec_Type IS RECORD
53: (

Line 94: estimate_quantity cs_estimate_details.quantity_required%type ,

90: repair_number csd_repairs.repair_number%type,
91: repair_line_id csd_repairs.repair_line_id%type,
92: ro_uom csd_repairs.unit_of_measure%type ,
93: ro_item_id csd_repairs.inventory_item_id%type ,
94: estimate_quantity cs_estimate_details.quantity_required%type ,
95: prod_txn_serial_num csd_product_transactions.source_serial_number%type ,
96: source_instance_id csd_product_transactions.source_instance_id%type,
97: product_transaction_id csd_product_transactions.product_transaction_id%type,
98: action_code csd_product_transactions.action_code%type,

Line 2205: cs_estimate_details ced,

2201: abs(ced.quantity_required) estimate_quantity,
2202: ced.order_line_id est_order_line_id,
2203: ced.inventory_item_id prod_txn_item_id
2204: FROM csd_product_transactions cpt,
2205: cs_estimate_details ced,
2206: csd_repairs cra,
2207: rcv_transactions rcvt,
2208: oe_order_headers_all oeh,
2209: oe_order_lines_all oel,

Line 2283: cs_estimate_details ced,

2279: abs(ced.quantity_required) estimate_quantity,
2280: ced.order_line_id est_order_line_id,
2281: ced.inventory_item_id prod_txn_item_id
2282: FROM csd_product_transactions cpt,
2283: cs_estimate_details ced,
2284: csd_repairs cra,
2285: rcv_transactions rcvt,
2286: oe_order_headers_all oeh,
2287: oe_order_lines_all oel,

Line 2360: cs_estimate_details ced,

2356: csd_repairs cra,
2357: oe_order_headers_all oeh,
2358: oe_order_lines_all oel,
2359: rcv_transactions rcvt,
2360: cs_estimate_details ced,
2361: csd_product_transactions cpt
2362: WHERE cpt.repair_line_id = p_repair_line_id
2363: AND cpt.action_type in ('RMA', 'RMA_THIRD_PTY') -- excluded walk-in-receipt as it is going off
2364: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')

Line 2405: cs_estimate_details ced,

2401: --- cursor for Cancelled orders...
2402: CURSOR Cur_Cancelled_repair_lines IS
2403: SELECT cra.REPAIR_LINE_ID
2404: FROM csd_repairs cra,
2405: cs_estimate_details ced,
2406: csd_product_transactions cpt
2407: WHERE cpt.action_type in ('RMA', 'RMA_THIRD_PTY')
2408: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')
2409: AND ced.order_header_id is not null

Line 2989: UPDATE CS_ESTIMATE_DETAILS

2985: FND_MSG_PUB.ADD;
2986:
2987: --bug#13505961
2988: --need to update the received organization_id
2989: UPDATE CS_ESTIMATE_DETAILS
2990: set transaction_inventory_org = i.organization_id
2991: where estimate_detail_id = (select estimate_detail_id from CSD_PRODUCT_TRANSACTIONS
2992: where product_transaction_id = i.product_transaction_id);
2993:

Line 6383: cs_estimate_details ced,

6379: wnd.name delivery_name,
6380: hao.name org_name
6381: from
6382: csd_product_transactions cpt,
6383: cs_estimate_details ced,
6384: csd_repairs cra,
6385: wsh_delivery_details dd ,
6386: wsh_serial_numbers dsn,--Added to fix 3801614
6387: --Changed to view from table, bug: 4341784

Line 6460: cs_estimate_details ced,

6456: wnd.name delivery_name,
6457: hao.name org_name
6458: from
6459: csd_product_transactions cpt,
6460: cs_estimate_details ced,
6461: csd_repairs cra,
6462: wsh_delivery_details dd ,
6463: wsh_serial_numbers dsn,--Added to fix 3801614
6464: --Changed to view from table, bug: 4341784

Line 6545: cs_estimate_details ced,

6541: wnd.name delivery_name,
6542: hao.name org_name
6543: from
6544: csd_product_transactions cpt,
6545: cs_estimate_details ced,
6546: csd_repairs cra,
6547: wsh_delivery_details dd ,
6548: wsh_serial_numbers dsn,--Added to fix 3801614
6549: --Changed to view from table, bug: 4341784

Line 6587: cs_estimate_details ced,

6583: --- cursor for Cancelled orders...
6584: CURSOR Cur_Cancelled_repair_lines IS
6585: SELECT cra.REPAIR_LINE_ID
6586: FROM csd_repairs cra,
6587: cs_estimate_details ced,
6588: csd_product_transactions cpt
6589: WHERE cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY')
6590: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')
6591: AND ced.order_header_id is not null

Line 9712: cs_estimate_details b,

9708:
9709: CURSOR c_product_transaction_id(p_repair_line_id IN number) is
9710: SELECT c.product_transaction_id, a.booked_flag
9711: FROM oe_order_lines_all a,
9712: cs_estimate_details b,
9713: csd_product_transactions c
9714: WHERE a.line_id = b.order_line_id
9715: AND b.estimate_detail_id = c.estimate_detail_id
9716: and c.prod_txn_status = 'SUBMITTED'

Line 9722: from cs_estimate_details p, csd_product_transactions q

9718: and c.book_sales_order_flag = 'N'
9719: and b.order_header_id in
9720: (
9721: select p.order_header_id
9722: from cs_estimate_details p, csd_product_transactions q
9723: where p.estimate_detail_id=q.estimate_detail_id
9724: and q.repair_line_id=p_repair_line_id
9725: );
9726:

Line 9773: cs_estimate_details ced,

9769: CURSOR CANCELLED_ORDER_LINES(p_repair_line_id NUMBER) IS
9770: SELECT DISTINCT cpt.product_transaction_id PRODUCT_TXN_ID
9771: FROM oe_order_headers_all oeh,
9772: oe_order_lines_all oel,
9773: cs_estimate_details ced,
9774: csd_product_transactions cpt
9775: WHERE cpt.repair_line_id = p_repair_line_id
9776: AND cpt.action_type in ('RMA', 'SHIP', 'RMA_THIRD_PTY', 'SHIP_THIRD_PTY')
9777: AND cpt.prod_txn_status in ( 'BOOKED', 'SUBMITTED')

Line 9883: cs_estimate_details est

9879: est.original_source_id,
9880: est.line_category_code,
9881: est.order_header_id
9882: from
9883: cs_estimate_details est
9884: where
9885: est.order_line_id = p_line_id;
9886:
9887: BEGIN