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.OKC_TERMS_MIGRATE_GRP dependencies on OKC_DELIVERABLE_TYPES_B

Line 3879: okc_deliverable_types_b deltypes

3875: SELECT 'Y'
3876: FROM okc_bus_doc_events_v evts,
3877: okc_bus_doc_types_b doctypes,
3878: okc_del_bus_doc_combxns delcomb,
3879: okc_deliverable_types_b deltypes
3880: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3881: AND deltypes.deliverable_type_code = p_deliverable_type
3882: AND doctypes.document_type_class = delcomb.document_type_class
3883: AND deltypes.deliverable_type_code = delcomb.deliverable_type_code

Line 3894: okc_deliverable_types_b deltypes

3890: SELECT 'Y'
3891: FROM okc_bus_doc_events_v evts,
3892: okc_bus_doc_types_b doctypes,
3893: okc_del_bus_doc_combxns delcomb,
3894: okc_deliverable_types_b deltypes
3895: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3896: AND deltypes.deliverable_type_code = p_deliverable_type
3897: AND doctypes.document_type_class = delcomb.document_type_class
3898: AND deltypes.deliverable_type_code = delcomb.deliverable_type_code

Line 3909: okc_deliverable_types_b deltypes

3905: SELECT 'Y'
3906: FROM okc_bus_doc_events_v evts,
3907: okc_bus_doc_types_b doctypes,
3908: okc_del_bus_doc_combxns delcomb,
3909: okc_deliverable_types_b deltypes
3910: WHERE 1=1
3911: AND evts.bus_doc_event_id = p_bus_doc_event_id
3912: AND deltypes.deliverable_type_code = p_deliverable_type
3913: AND doctypes.document_type_class = delcomb.document_type_class

Line 3954: okc_deliverable_types_b delTypes

3950: IS
3951: select 'Y'
3952: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3953: okc_del_bus_doc_combxns delComb,
3954: okc_deliverable_types_b delTypes
3955: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3956: AND delTypes.deliverable_type_code = p_deliverable_type
3957: AND docTypes.document_type_class = delComb.document_type_class
3958: AND delTypes.deliverable_type_code = delComb.deliverable_type_code

Line 3968: okc_deliverable_types_b delTypes

3964:
3965: select 'Y'
3966: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3967: okc_del_bus_doc_combxns delComb,
3968: okc_deliverable_types_b delTypes
3969: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3970: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType
3971: AND docTypes.document_type_class = delComb.document_type_class
3972: AND delTypes.deliverable_type_code = delComb.deliverable_type_code

Line 3982: okc_deliverable_types_b delTypes

3978:
3979: select 'Y'
3980: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3981: okc_del_bus_doc_combxns delComb,
3982: okc_deliverable_types_b delTypes
3983: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3984: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType
3985: AND docTypes.document_type_class = delComb.document_type_class
3986: AND delTypes.deliverable_type_code = delComb.deliverable_type_code

Line 3997: okc_deliverable_types_b del_types

3993: select 'Y'
3994: from okc_bus_doc_events_v evts,
3995: okc_bus_doc_types_b doc_types,
3996: okc_del_bus_doc_combxns delComb,
3997: okc_deliverable_types_b del_types
3998:
3999: WHERE
4000: evts.bus_doc_event_id = p_bus_doc_event_id --:start event id
4001: and start_end_qualifier = 'START'

Line 4012: okc_deliverable_types_b delTypes

4008:
4009: select 'Y'
4010: FROM okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
4011: okc_del_bus_doc_combxns delComb,
4012: okc_deliverable_types_b delTypes
4013: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
4014: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType
4015: AND docTypes.document_type_class = delComb.document_type_class
4016: AND delTypes.deliverable_type_code = delComb.deliverable_type_code

Line 4065: SELECT 'Y' FROM okc_deliverable_types_b

4061: WHERE document_type = p_doc_type;
4062:
4063: CURSOR cur_val_del_type (p_del_type VARCHAR2)
4064: IS
4065: SELECT 'Y' FROM okc_deliverable_types_b
4066: WHERE deliverable_type_code = p_del_type;
4067:
4068: CURSOR cur_val_resp_party (p_intent VARCHAR2,p_bus_doc_class VARCHAR2)
4069: IS