DBA Data[Home] [Help]

APPS.OE_2PC2_CONFIG_PURREL dependencies on OE_AK_ORDER_LINES_V

Line 30: FROM OE_AK_ORDER_LINES_V b

26: AND w.activity_status = l_wf_activity_status_code
27: AND w.activity_result_code = l_wf_activity_result_code
28: AND w.item_key IN
29: ( SELECT b.LINE_ID || ''
30: FROM OE_AK_ORDER_LINES_V b
31: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
32: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
33: );
34:

Line 37: FROM OE_AK_ORDER_LINES_V b

33: );
34:
35: CURSOR C_RSC IS
36: SELECT count(*)
37: FROM OE_AK_ORDER_LINES_V b
38: WHERE b.HEADER_ID = OE_LINE_SECURITY.g_record.HEADER_ID
39: AND b.TOP_MODEL_LINE_ID = OE_LINE_SECURITY.g_record.TOP_MODEL_LINE_ID
40: ;
41: