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.CSF_DEBRIEF_PVT dependencies on CS_TRANSACTION_TYPES

Line 1011: cs_transaction_types_vl cttv

1007:
1008: cursor c_cp_status(p_transaction_type_id number) is
1009: select ctst.src_status_id
1010: from csi_txn_sub_types ctst ,
1011: cs_transaction_types_vl cttv
1012: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1013: and cttv.transaction_type_id = p_transaction_type_id;
1014:
1015: cursor c_cp_status_notnull (p_cp_status varchar2) is

Line 1029: from cs_transaction_types_vl cttv,

1025: cursor c_txn_billing_type_id (p_txn_billing_type_id number) is
1026: select ctbt.billing_type,
1027: cttv.line_order_category_code,
1028: cttv.transaction_type_id
1029: from cs_transaction_types_vl cttv,
1030: cs_txn_billing_types ctbt
1031: where ctbt.txn_billing_type_id = p_txn_billing_type_id
1032: and ctbt.transaction_type_id = cttv.transaction_type_id;
1033:

Line 1038: from cs_transaction_types_vl cttv,

1034: cursor c_transaction_type_id (p_transaction_type_id number,
1035: p_inventory_item_id number) is
1036: select ctbt.billing_type,
1037: cttv.line_order_category_code
1038: from cs_transaction_types_vl cttv,
1039: cs_txn_billing_types ctbt,
1040: mtl_system_items_b_kfv msibk
1041: where cttv.transaction_type_id = p_transaction_type_id
1042: and cttv.transaction_type_id = ctbt.transaction_type_id

Line 1837: cs_transaction_types_vl cttv

1833:
1834: cursor c_cp_status(p_transaction_type_id number) is
1835: select ctst.src_status_id
1836: from csi_txn_sub_types ctst ,
1837: cs_transaction_types_vl cttv
1838: where ctst.cs_transaction_type_id = cttv.transaction_type_id
1839: and cttv.transaction_type_id = p_transaction_type_id;
1840:
1841: cursor c_cp_status_notnull (p_cp_status varchar2) is

Line 2711: from cs_transaction_types vl

2707: IS
2708: l_dummy number;
2709: cursor get_transaction_type_id is
2710: select 1
2711: from cs_transaction_types vl
2712: where transaction_type_id=P_Transaction_type_id;
2713: BEGIN
2714: -- Initialize message list if p_init_msg_list is set to TRUE.
2715: IF FND_API.to_Boolean( p_init_msg_list )

Line 3325: cs_transaction_types ctt

3321: select min(labor_start_date),
3322: max(labor_end_date),
3323: min(debrief_line_id)
3324: from csf_debrief_lab_lines_v cdl,
3325: cs_transaction_types ctt
3326: where cdl.debrief_header_id = p_debrief_header_id
3327: and cdl.transaction_type_id = ctt.transaction_type_id
3328: and ctt.line_order_category_code = 'ORDER';
3329:

Line 3335: cs_transaction_types ctt

3331: select min(labor_start_date),
3332: max(labor_end_date),
3333: min(debrief_line_id)
3334: from csf_debrief_lab_lines_v cdl,
3335: cs_transaction_types ctt
3336: where cdl.debrief_header_id = p_debrief_header_id
3337: and cdl.transaction_type_id = ctt.transaction_type_id
3338: and ctt.line_order_category_code = 'RETURN'
3339: and cdl.labor_start_date between p_start_date_order and p_end_date_order

Line 3349: cs_transaction_types ctt

3345: min(debrief_line_id)
3346: from csf_debrief_lab_lines_v cdl,
3347: csf_debrief_headers cdh,
3348: jtf_task_assignments jta,
3349: cs_transaction_types ctt
3350: where jta.task_id = l_task_id
3351: and jta.task_assignment_id = cdh.task_assignment_id
3352: and cdh.debrief_header_id = cdl.debrief_header_id
3353: and cdl.transaction_type_id = ctt.transaction_type_id

Line 3363: cs_transaction_types ctt

3359: min(debrief_line_id)
3360: from csf_debrief_lab_lines_v cdl,
3361: csf_debrief_headers cdh,
3362: jtf_task_assignments jta,
3363: cs_transaction_types ctt
3364: where jta.task_id = l_task_id
3365: and jta.task_assignment_id = cdh.task_assignment_id
3366: and cdh.debrief_header_id = cdl.debrief_header_id
3367: and cdl.transaction_type_id = ctt.transaction_type_id

Line 3379: cs_transaction_types ctt

3375: from csf_debrief_lines cdl,
3376: csf_debrief_headers cdh,
3377: jtf_task_assignments jta,
3378: jtf_tasks_b jtb,
3379: cs_transaction_types ctt
3380: where jtb.parent_task_id = l_parent_task_id
3381: and jta.task_id = jtb.task_id
3382: and jta.task_assignment_id = cdh.task_assignment_id
3383: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3394: cs_transaction_types ctt

3390: from csf_debrief_lines cdl,
3391: csf_debrief_headers cdh,
3392: jtf_task_assignments jta,
3393: jtf_tasks_b jtb,
3394: cs_transaction_types ctt
3395: where jtb.parent_task_id = l_parent_task_id
3396: and jta.task_id = jtb.task_id
3397: and jta.task_assignment_id = cdh.task_assignment_id
3398: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3414: cs_transaction_types ctt

3410: select uom_code, quantity
3411: from jtf_task_assignments jta,
3412: csf_debrief_headers cdh,
3413: csf_debrief_lines cdl,
3414: cs_transaction_types ctt
3415: where cdh.debrief_header_id = cdl.debrief_header_id
3416: and jta.task_assignment_id = cdh.task_assignment_id
3417: and cdh.debrief_header_id = p_debrief_header_id
3418: and cdl.transaction_type_id = ctt.transaction_type_id

Line 3433: cs_transaction_types ctt

3429: select uom_code, (quantity * -1)
3430: from jtf_task_assignments jta,
3431: csf_debrief_headers cdh,
3432: csf_debrief_lines cdl,
3433: cs_transaction_types ctt
3434: where cdh.debrief_header_id = cdl.debrief_header_id
3435: and jta.task_assignment_id = cdh.task_assignment_id
3436: and cdh.debrief_header_id = p_debrief_header_id
3437: and cdl.transaction_type_id = ctt.transaction_type_id

Line 3454: cs_transaction_types ctt

3450: from csf_debrief_lines cdl,
3451: csf_debrief_headers cdh,
3452: jtf_task_assignments jta,
3453: jtf_tasks_b jtb,
3454: cs_transaction_types ctt
3455: where cdh.debrief_header_id = cdl.debrief_header_id
3456: and jta.task_assignment_id = cdh.task_assignment_id
3457: and cdl.transaction_type_id = ctt.transaction_type_id
3458: and ctt.line_order_category_code = 'ORDER'

Line 3475: cs_transaction_types ctt

3471: from csf_debrief_lines cdl,
3472: csf_debrief_headers cdh,
3473: jtf_task_assignments jta,
3474: jtf_tasks_b jtb,
3475: cs_transaction_types ctt
3476: where cdh.debrief_header_id = cdl.debrief_header_id
3477: and jta.task_assignment_id = cdh.task_assignment_id
3478: and cdl.transaction_type_id = ctt.transaction_type_id
3479: and ctt.line_order_category_code = 'RETURN'

Line 3497: cs_transaction_types ctt

3493: from csf_debrief_lines cdl,
3494: csf_debrief_headers cdh,
3495: jtf_task_assignments jta,
3496: jtf_tasks_b jtb,
3497: cs_transaction_types ctt
3498: where cdh.debrief_header_id = cdl.debrief_header_id
3499: and jta.task_assignment_id = cdh.task_assignment_id
3500: and cdl.transaction_type_id = ctt.transaction_type_id
3501: and ctt.line_order_category_code = 'ORDER'

Line 3518: cs_transaction_types ctt

3514: from csf_debrief_lines cdl,
3515: csf_debrief_headers cdh,
3516: jtf_task_assignments jta,
3517: jtf_tasks_b jtb,
3518: cs_transaction_types ctt
3519: where cdh.debrief_header_id = cdl.debrief_header_id
3520: and jta.task_assignment_id = cdh.task_assignment_id
3521: and cdl.transaction_type_id = ctt.transaction_type_id
3522: and ctt.line_order_category_code = 'RETURN'