DBA Data[Home] [Help]

APPS.OEXBMCBK dependencies on SO_LINES_ALL

Line 53: UPDATE SO_LINES_ALL

49: -- when linking the configuration item
50:
51: stmt_number := 2;
52:
53: UPDATE SO_LINES_ALL
54: SET S27 = 23
55: WHERE HEADER_ID = header_id
56: AND (LINE_ID = dem_src_line
57: OR ATO_LINE_ID = dem_src_line)

Line 67: UPDATE SO_LINES_ALL

63: -- when delinking the configuration item
64:
65: stmt_number := 3;
66:
67: UPDATE SO_LINES_ALL
68: SET S27 = 4
69: WHERE HEADER_ID = header_id
70: AND (LINE_ID = dem_src_line
71: OR ATO_LINE_ID = dem_src_line)

Line 78: FROM SO_LINES_ALL

74: (SELECT 'Released Details'
75: FROM SO_LINE_DETAILS
76: WHERE LINE_ID IN
77: (SELECT LINE_ID
78: FROM SO_LINES_ALL
79: WHERE LINE_ID = dem_src_line)
80: AND INVENTORY_ITEM_ID = config_item_id
81: AND RELEASED_FLAG = 'Y');
82: